Arrays - Help

From: YoMan <rajamohan.kartha_at_silverline.com>
Date: 15 Oct 2001 14:19:08 -0700
Message-ID: <9afeb442.0110151319.79055459_at_posting.google.com>

Hi all,

I am trying to receive an array(table) from a java program. I have to use this array(table) in a dynamic select statement and send back a cursor. I have searched in the net but no help. If any one have done this please send the sample code so I can implement this. My code look some thing like this

PROCEDURE getArraySamples(SampleArray IN SampleIdArray,

			Sample_cur OUT TBSample_cur,
		     	ret_status OUT SMALLINT) IS

sql_stmt VARCHAR2(1000);
c number;

handle integer;
BEGIN

        <create a dynamic statement to the cursor.>
	OPEN Sample_cur FOR sql_stmt using SampleArray;
	
EXCEPTION
	WHEN OTHERS THEN
	ret_status := SQLCODE;

END getArraySamples; Received on Mon Oct 15 2001 - 23:19:08 CEST