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: 25477
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: working plsql code need for this simple scenerio
Next Topic: Count Business Days - Brio software - Oracle DB
Goto Forum:

Current Time: Tue Jun 27 17:43:04 CDT 2017

Total time taken to generate the page: 0.11852 seconds