Home » SQL & PL/SQL » SQL & PL/SQL » Result set (Oracle 9i)
Result set [message #329894] Fri, 27 June 2008 00:08 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
I would like to pass the entier data of one column in a table through procedure as out parameter using except collections.How to do that?
Re: Result set [message #329897 is a reply to message #329894] Fri, 27 June 2008 00:11 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
with much difficulty.
Re: Result set [message #329899 is a reply to message #329897] Fri, 27 June 2008 00:15 Go to previous messageGo to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Kindly suggests how to do that?
Re: Result set [message #329900 is a reply to message #329894] Fri, 27 June 2008 00:17 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
What make you think it is possible in a dynamic & multi-user application?
Re: Result set [message #329957 is a reply to message #329897] Fri, 27 June 2008 02:29 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'd pass a ref cursor pointing to a query that selected the data you require.
Previous Topic: insert from remote server to client table
Next Topic: PASS A TABLE NAME AS A PARAMETER IN PL/SQL?
Goto Forum:
  


Current Time: Thu Dec 08 14:20:10 CST 2016

Total time taken to generate the page: 0.06792 seconds