This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
To my stored procedure , i need to pass some numbers which can be used in the IN clause of select query of a cursor.
For this i had created a type and a function to get the array . Using that array , i have tried to put in a variable of type varchar.
I have used that new variable in the IN clause of the select query of a cursor. I am getting ORA-01722 error.