proc open cursor

Hi,

in the ( fragment ) of my program below the cursor seems to stay open after the "EXEC SQL CLOSE CU;" statement! the sqlca.sqlcode is 0 for all statements!

even the sqlplus statement
select user_name, sql_text from v$open_cursor; shows the cursor open at the time the read waits for input.

EXEC SQL declare cu cursor for select * from tbl; EXEC SQL open cu ;
EXEC SQL fetch cu into :result ;
EXEC SQL close cu ;
read(1,input,1);

i am using oracle 8.1.5 on linux

thanks,

udo Received on Thu Mar 09 2000 - 07:09:08 CST