TimHall,

In the future I will surely use the same thread. I never knew that I can continue using the same thread. ThanX a lot for help . . . and I mean it.


Here is a new problem I am facing.

I am receiving an array as IN paramter. Can I use this array in a dynamic SQL stmt created in the procedure using USING clause?. If YES please help me with a snippet code

Somthing like this

TYPE vAryAssayId IS VARRAY(1000) OF NUMBER(10);

create or repalce PROCEDURE GetMatch ( InAry IN vAryAssayId) IS
begin
sql_stmt := 'select * from TableA WHERE xyz = :aa';
open abc for sql_stmt USING InAry;
END GetMatch;

Once again Sorry for making too many threads. TimHall ThanX a lot for the eye opener.

Raj