Home » SQL & PL/SQL » SQL & PL/SQL » Passing a recordset
Passing a recordset [message #37728] Mon, 25 February 2002 12:23 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
How can I sucessfully pass a resultset into another procedure to be used in a Select statement within an IN() clause? The resultset is just a single column. I tried passing a SQL statement to use in the IN() but it looks like the statement never runs. Either solution is viable but I can't get either to fully execute.

Thanks for some assistance, Sam

procedure Proc1 is
Begin
...
ProcCommon(vResultSet);
...
End;

Procedure ProcCommon(pRecordset IN ????) is

Cursor cMain is
SELECT * FROM Table1 where cust_id IN (pRecordset);

begin
open cMain;
...

End;

Report message to a moderator

Re: Passing a recordset [message #37737 is a reply to message #37728] Tue, 26 February 2002 02:45 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
u r passing the recordset in correct way. but u can not use that in in clause, as it expects a list of value or a sub-query.

Report message to a moderator

Previous Topic: Error i cannot make sense of
Next Topic: synonims and index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 07:37:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.