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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 13:15:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.