This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes SQLException: unsupported construct or internal error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQLException: unsupported construct or internal error " Watch "SQLException: unsupported construct or internal error " New topic
Author

SQLException: unsupported construct or internal error

Joseph Leo
Greenhorn

Joined: Apr 13, 2004
Posts: 1
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: SQLException: unsupported construct or internal error
 
It's not a secret anymore!