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

[nadjim chetbani]

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]

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]

Thanks for our reply.
Yes, I Can execute "myrecrtn()" successfully from SQL*Plus !
Thanks in advance,
Nadjim