Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sysrsh

    select statement using 'IN' and NVL

    Hi Gunjan, Thanks for replying so promptly. Coming from a SQL Server background, PLSQL is a real challenge. I'm getting the following error when I execute my stored proc. ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "PARSELIST&quot...
  2. sysrsh

    select statement using 'IN' and NVL

    Hi Dima, I am facing the same problem in one of my plsql procedures. I created the parseString function. How should I pass the parameters to the stored proc as ? For instance I want to search on user_id IN('abc','def'). How should I be passing this to the stored proc ? Thanks. sysrsh

Part and Inventory Search

Back
Top