Home » Developer & Programmer » JDeveloper, Java & XML » getting No Data Found Exception while calling a procedure in oracle from Java Program
getting No Data Found Exception while calling a procedure in oracle from Java Program [message #92174] Thu, 01 April 2004 20:00 Go to next message
ShriDevi
Messages: 2
Registered: April 2004
Junior Member
hi
i have one procedure named find in stud.sql file.while trying to call this procedure from a java program using JDBC Callable statement ,i am getting " Exception : java.sql.SQLException: ORA-01403: no data found"

this my call
CallableStatement cs=con.prepareCall("{call find(100,?,?,?)}");

how to rectify this ,can anyone clarify my doubt
Re: getting No Data Found Exception while calling a procedure in oracle from Java Program [message #92183 is a reply to message #92174] Mon, 05 April 2004 00:50 Go to previous message
Magnar Johannessen
Messages: 12
Registered: February 2004
Junior Member
Hi,
The NO_DATA_FOUND Exception is being "thrown" in the procedure not in Java.
Check your procedure and add exception handling.

mj
Previous Topic: HTTP Header manipulation?
Next Topic: sql exception
Goto Forum:
  


Current Time: Tue Jul 27 16:35:11 CDT 2021