Hi,
I am creating a procedure which takes an array and a numeric value as input and returns 2 arrays and a resultset , signature is as follows :
where TA_ITEM_CODE is a type :
In procedure I want to retrieve some values according to some condition, Query which i want to execute is :
In above code bar_codes is an array which i'll send from
java.
When I'm trying to compile the procedure in Oracle it is giving me exception "Expected number but found TA_ITEM_CODE". I'm not able to understand why its giving an error
because
itm.ITEM_NO is of type Varchar in Item table. Please help me where I'm going wrong. Just for the reference following is my java code
which i'll use to call this procedure once it will compile properly :
Thanks in Advance,
Namrta.