This week's book giveaway is in the OCAJP forum. We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line! See this thread for details.
I am facing a problem while writing a procedure .... please help me on this ....
I have to pass the parameter of type varchar2 to procedure . The parameter can have value like 1,2,3 .
Using that parameter i have to get some values from one table say 'select id from YY where XX in (input parameter);' I am getting ORA-01722 and ORA-06512 errors while execting the procedure . We are using Oracle 10 G .
How do i split the values ?
posted 6 years ago
What type is XX? If XX is a number and your input parameter is a VARCHAR that would be your problem.