|Soft Close Cursor [message #327808]
||Tue, 17 June 2008 13:51
Registered: July 2005
I'm currently reading a book that tells about soft-closed cursor, i tried checking my recently executed select statement in the v$open_cursor. Tried some of this statements:
select 'openA' from dual;
WHERE INSTR(UPPER(sql_text),'OPENA') > 0
AND INSTR(UPPER(sql_text),'SQL_TEXT') = 0
AND command_type = 3;
--and sql_id = 'ajut3t2v0m7sc'
and sql_text like '%openA%';
Still cant find my recent query on that cursor. Please advise if there's anything I miss or did not understand in the steps.
Also related to that soft-close cursor, I tried setting my open_cursors parameter to lower like 5 or 10, then issued a sequence of impicit cursors inside a block, but it did not return the error maximum cursors allowed. The code is like this:
cursor a is
select 'a' from dual;
cursor b is
select 'b' from dual;
fetch a into v_t;
--not closing it
fetch b into v_t;
...and so on....
Thank you so much for your help.
[Updated on: Tue, 17 June 2008 13:54]
Report message to a moderator