OraFAQ Forum: SQL & PL/SQL » procedure out parameter

Home » SQL & PL/SQL » SQL & PL/SQL » procedure out parameter (oracle 10g)

Thu, 30 January 2014 23:48

vivek_rol
Messages: 65
Registered: February 2009

Member

can we use procedure OUT parameter as cursor ?

if yes then HOW ?

Thu, 30 January 2014 23:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When all else fails Read The Fine Manual yourself

http://docs.oracle.com/cd/E16655_01/server.121/e17633/glossary.htm#CNCPT44457

so what is the answer to your question, now?

Fri, 31 January 2014 00:58

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

A cursor, no; but a ref cursor, yes.

See Cursor Variables.

Previous Topic:	exceptions
Next Topic:	Remove special characters

Goto Forum:

]

Current Time: Thu Apr 25 18:05:21 CDT 2024