OraFAQ Forum: SQL & PL/SQL » where we will use Cursor in Fun and Procedure?

Home » SQL & PL/SQL » SQL & PL/SQL » where we will use Cursor in Fun and Procedure?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

where we will use Cursor in Fun and Procedure? [message #223852]

Mon, 12 March 2007 01:54

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

I have some doubt in Function and Procedure?
where we will use Cursor in Fun and Procedure?

example:

create function f1 (parameter) return number
is
cursor c1 is select * from emp;

Begin
pl/ssql statement;
End;

Report message to a moderator

Re: where we will use Cursor in Fun and Procedure? [message #223860 is a reply to message #223852]

Mon, 12 March 2007 02:15

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

Please clarify the question.

Report message to a moderator

Re: where we will use Cursor in Fun and Procedure? [message #223871 is a reply to message #223860]

Mon, 12 March 2007 02:58

soni_7
Messages: 33
Registered: July 2005

Member

If you are asking where you need to define the cursor, then what you have written is correct. You can use it(open ,fetch etc.) inside begin - end.
Hope this is what you require. If not, then do elaborate more on your query.

Cheers ~
Sony

Report message to a moderator

Previous Topic:	package UTL_FILE
Next Topic:	difference between cursor and refcursor ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 19:50:14 CST 2024