%ISOPEN

The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

 

IF c1%ISOPEN THEN -- cursor is open

...

ELSE -- cursor is closed, so open it

OPEN c1;

END IF;

Posted Date: 10/4/2012 4:10:19 AM | Location : United States

Ask an Expert

Related Discussions:- %isopen - explicit cursor attributes, Assignment Help, Ask Question on %isopen - explicit cursor attributes, Get Answer, Expert's Help, %isopen - explicit cursor attributes Discussions

Write discussion on %isopen - explicit cursor attributes
Your posts are moderated

Write your message here..

Related Questions

Aggregate assignment-declarations in sql, Aggregate Assignment The %ROWT... Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Testing triggers, Demonstrate your knowledge of PL/SQL programming by writi... Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Declaring records, Declaring Records Whenever you define a RECORD type... Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

Effects of null for table expression, Effects of NULL for Table Expression ... Effects of NULL for Table Expression Here's an important distinction between expressions denoting tables and expressions denoting multisets of rows: a table expression cannot

%found - implicit cursor attributes, %FOUND Until the SQL data manipul... %FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

Tautology - equivalences rules, Tautology - Equivalences Rules: If the... Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta

Using set transaction, Using SET TRANSACTION You use the SET TRANSACTI... Using SET TRANSACTION You use the SET TRANSACTION statement to begin the read-only or read-write transaction, start an isolation level, or assign your present transaction to a

Use of table expressions - expressing constraint conditions, Use of Table E... Use of Table Expressions - Expressing Constraint Conditions With the exception of key constraints, the examples in the theory book all explicitly reference at least one relvar

Defining autonomous transactions, Defining Autonomous Transactions To ... Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

What is a record, What Is a Record  ? A record is a group of related... What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em