dcsimg
ORA-01403: no data found
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Thursday, August 25, 2005 11:01 AM

when I call procedure I got this error. java.sql.SQLException: ORA-01403: no data found html tags to format code blocks. my code is: String query="{ call P_HASTAHIZMETINSERT(?,?,?,?,?,?,?,?,?,?,?,?) }"; CallableStatement stmt = conn.prepareCall(query); stmt.setInt(1,145); stmt.setString(2,"520320"); stmt.setDate(3,date); stmt.setInt(4,1); stmt.setInt(5,24); stmt.setString(6,"Ahmet"); stmt.setString(7,"IG"); stmt.setString(8," "); stmt.setString(9,"MRK"); stmt   More>>

when I call procedure I got this error.



java.sql.SQLException: ORA-01403: no data found html tags to format code blocks.


my code is:

String query="{ call P_HASTAHIZMETINSERT(?,?,?,?,?,?,?,?,?,?,?,?) }";


CallableStatement stmt = conn.prepareCall(query);


stmt.setInt(1,145);


stmt.setString(2,"520320");


stmt.setDate(3,date);


stmt.setInt(4,1);


stmt.setInt(5,24);


stmt.setString(6,"Ahmet");


stmt.setString(7,"IG");


stmt.setString(8," ");


stmt.setString(9,"MRK");


stmt.setString(10,"MRKP");


stmt.setString(11,"232");


stmt.setString(12,"85");



stmt.execute();





stmt.close();


conn.close();





please anyone help!!!


   <<Less

Re: ORA-01403: no data found

Posted By:   David_Thornton  
Posted On:   Thursday, August 25, 2005 08:16 PM

This is a problem with your Oracle PLSQL procedure and not JDBC. The most likely cause is that in your PLSQL procedure you executed a SELECT INTO statement and no rows were returned.
About | Sitemap | Contact