Passing a recordset [message #37728] |
Mon, 25 February 2002 12:23 |
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;
|
|
|
|