I have a stored procedure in Oracle that compiles and executes correctly. When I call the same from java (jdbc thin driver) I get the following error message:
java.sql.SQLException: ORA-06550: line 1, column 47:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
Can someone give me advice as to what maybe the problem...
thanks
SK
Your provided information will not help anyone to resolve this problem properly unless you write the snap of procedure and how you are calling it from java.
Regards
I was unable to make any straight java work but was able to get the sequence / key assigned back from a stored procedure so now I am trying to call that stored procedure from java.
SQLquery =
" DECLARE x report_help.seqid%TYPE; " +
" BEGIN " +
" INSERT INTO report_help " +
" ( helptext, creationdate) " +
" VALUES ( ? ,SYSDATE) " +
" RETURNING seqid INTO x" +
" END";
int x = 0;
CallableStatement cstmt = null;
try
{
cstmt = dbConn.prepareCall(SQLquery);
cstmt.setString(1, v_helptext );
cstmt.executeQuery();
if (rs.next()) {
x = rs.getInt(1);
}
cstmt.close();
} catch(SQLException ex) {
I am also getting
java.sql.SQLException: ORA-06550: line 1, column 47:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
...