aspose file tools*
The moose likes JDBC and the fly likes java.sql.SQLException: ORA-06550: line 1, column 13 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: ORA-06550: line 1, column 13" Watch "java.sql.SQLException: ORA-06550: line 1, column 13" New topic
Author

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

nadjim chetbani
Greenhorn

Joined: Feb 10, 2003
Posts: 2
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

Joined: Oct 11, 2000
Posts: 1124

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

Joined: Feb 10, 2003
Posts: 2
Thanks for our reply.
Yes, I Can execute "myrecrtn()" successfully from SQL*Plus !
Thanks in advance,
Nadjim
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: ORA-06550: line 1, column 13