Home » SQL & PL/SQL » SQL & PL/SQL » Can I use a procedure to run a SELECT query ?
Can I use a procedure to run a SELECT query ? [message #7576] Mon, 23 June 2003 05:16 Go to next message
Ralph
Messages: 4
Registered: October 2001
Junior Member
Hi,

Is it possible to use a stored procedure/function to return the results of a SELECT query ?

Report message to a moderator

Re: Can I use a procedure to run a SELECT query ? [message #7577 is a reply to message #7576] Mon, 23 June 2003 06:28 Go to previous messageGo to next message
Smitha
Messages: 17
Registered: June 2001
Junior Member
You can use function in select query and i am not sure about the procedures... but the function has to return only one value.

Report message to a moderator

Re: Can I use a procedure to run a SELECT query ? [message #7586 is a reply to message #7576] Mon, 23 June 2003 15:53 Go to previous message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
Yes, you can use a stored procedure or function to return the results of a select query, using a ref cursor. Please click on the link below for further information by Tom Kyte.

Report message to a moderator

Previous Topic: To_date formats
Next Topic: Partition Join
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 12:10:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.