cursor out of reference
-
i'm accessing this .sql file from a .ksh(script) file. error-subprogram or cursor reference out of scope {code} declare CURSOR cur AS select a from abc; begin for i in cur loop dbms.putline('recored is' rec.recor_num); end loop
-
i'm accessing this .sql file from a .ksh(script) file. error-subprogram or cursor reference out of scope {code} declare CURSOR cur AS select a from abc; begin for i in cur loop dbms.putline('recored is' rec.recor_num); end loop
Where is your FETCH?
-
i'm accessing this .sql file from a .ksh(script) file. error-subprogram or cursor reference out of scope {code} declare CURSOR cur AS select a from abc; begin for i in cur loop dbms.putline('recored is' rec.recor_num); end loop
What database is this for as it doesn't look like a SQL Server cursor TSQL Cursor[^]
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
-
What database is this for as it doesn't look like a SQL Server cursor TSQL Cursor[^]
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
It looks like Oracle PL/SQL to me(I used this 7+ months ago so I could be wrong...)
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
i'm accessing this .sql file from a .ksh(script) file. error-subprogram or cursor reference out of scope {code} declare CURSOR cur AS select a from abc; begin for i in cur loop dbms.putline('recored is' rec.recor_num); end loop
Not used Oracle for a while but I would have a read of this Stackoverflow: pl-sql cursor[^] it shows how you would construct your cursor. I think your problem is here
GugliMugli wrote:
CURSOR cur AS select a from abc;
it should be
declare cursor cur is
select a from abcLobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
-
Not used Oracle for a while but I would have a read of this Stackoverflow: pl-sql cursor[^] it shows how you would construct your cursor. I think your problem is here
GugliMugli wrote:
CURSOR cur AS select a from abc;
it should be
declare cursor cur is
select a from abcLobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
sorry.. i mentioned 'AS' instead of 'IS'.. the complete cursor is CURSOR cur IS select a from abc. this is oracle pl/sql..
-
i'm accessing this .sql file from a .ksh(script) file. error-subprogram or cursor reference out of scope {code} declare CURSOR cur AS select a from abc; begin for i in cur loop dbms.putline('recored is' rec.recor_num); end loop
this is solved... thanks