• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: ORA-06550: line 1, column 13

 
nadjim chetbani
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thanks for ur reply. I tried it. But, it seems i cant call a function using callable statement. Bcos, it gave the error as
********************************************************
java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00201: identifier 'JAVA_XA.XA_START_NEW' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
...
...
*********************************************************
I have declared and defined MYRECRTN as function inside mypackage. I prepared the callable statement using "{call mypackage.myrecrtn()}".
Is there any other way to call a function from java???
Thanks in advance,
Nadjim
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nadjim,
According to your error message, the problem is not with your java code (that invokes the "myrecrtn()" procedure), but with the "myrecrtn()" procedure itself.
It looks like the "myrecrtn()" procedure is a java stored procedure, correct?
Can you successfully execute "myrecrtn()" from SQL*Plus?
Would it be possible to see the code for "myrecrtn()"?
Cheers,
Avi.
 
nadjim chetbani
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for our reply.
Yes, I Can execute "myrecrtn()" successfully from SQL*Plus !
Thanks in advance,
Nadjim
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic