Home » SQL & PL/SQL » SQL & PL/SQL » Cursors
Cursors [message #202014] Tue, 07 November 2006 21:07 Go to next message
Messages: 2
Registered: October 2006
Junior Member
Hi ,

My code is like this.Here the temp_table have some values and we need to set those values to the v_match,v_seqno(procedure variables) using cursor.but it giving me error that looping curloop is not valid.Does this code assign the column values of the table to the procedure variables?Please guide.

create procedure proce_name

v_match temp_table.match%type;
v_seqno temp_table.seno%type;
cursor c1 is
select * from temp_table;
for curloop in c1
v_match := curloop.match;
v_seqno := curloop.seqno;
end loop;
Re: Cursors [message #202022 is a reply to message #202014] Tue, 07 November 2006 22:05 Go to previous messageGo to next message
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
>but it giving me error
What error?
I do not see any error.
Next time try actual cut & paste; plus use <code> tags
Re: Cursors [message #202054 is a reply to message #202022] Wed, 08 November 2006 00:50 Go to previous message
Messages: 9
Registered: November 2006
Junior Member
the code is correct, but there is a syntax error you should specify is clause in place of declare clause. Hope this helps.
Previous Topic: Count Business Days - Brio software - Oracle DB
Next Topic: How to fix ORA-01632 error?
Goto Forum:

Current Time: Sat Aug 19 08:14:47 CDT 2017

Total time taken to generate the page: 0.04184 seconds