Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

SQLException: unsupported construct or internal error

 
Joseph Leo
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I tried to run my SQL Command,
callStmt = connection.prepareCall("call TMP1.SP_TEMP(?,?,?)");
callStmt.setInt(1, iEmp);
callStmt.setInt(2, iEmp+1);
callStmt.registerOutParameter(3, Types.REF, "PROJECT_ID_TYP2");
callStmt.execute();
But, i got an exception ....
Exception in DAO getTimesheetData : java.sql.SQLException:
ORA-06553: PLS-707: unsupported construct or internal error [2604]
SQLException: ORA-06553: PLS-707: unsupported construct or internal error [2604]
SQLState: 65000
VendorError: 6553
I'm using Oracle 8.1.7 version.
Could anyone please give me a solution for this?
Thanks in Advance for the help!
Regards,
Joseph.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!