cursor is open or not?

[kiss07]

Dear friends,

I write a program using oracle version 9i. in cursor .How can i find out

is a cursor is open or not? after that what is bind variable ? what is the use of

Bind variable in plsql?

Expecting your replies...


Arun..

[ManjunathRG]

Hi
There are many cursor attributes which you can use.
For your req.
use %is_open

Eg: if cursorname%is_open then...
code..


Bind variables are a method to improve performance of queries.
They are used usually with execute immediate stmts. in plsql.
A little bit of googling will you its syntax.

Dear friends,

I write a program using oracle version 9i. in cursor .How can i find out

is a cursor is open or not? after that what is bind variable ? what is the use of

Bind variable in plsql?

Expecting your replies...


Arun..

[debasisdas]

use cursor attrribute %ISOPEN

it returns boolean value ie(true/false)