my dog learned polymorphism*
The moose likes JDBC and the fly likes HELP!!! - inner exception : java.sql.SQLException: ORA-06550: Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HELP!!! - inner exception : java.sql.SQLException: ORA-06550: " Watch "HELP!!! - inner exception : java.sql.SQLException: ORA-06550: " New topic
Author

HELP!!! - inner exception : java.sql.SQLException: ORA-06550:

Arundhathi Menon
Ranch Hand

Joined: Jan 14, 2004
Posts: 113
Hi ,

I am trying to execute my stored procedure from Java. The argument type in the procedure is -Table_TYPE (outut argument)

In Java I have specified it as java.sql.Types.ARRAY. This results in the

inner exception : java.sql.SQLException: ORA-06550: line 1, column 7:


Can you please help!!

Thanks in advance
Menon


SCJP , SCWCD , SCBCD , SCDJWS
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

can you post your Stored Procedure and java code(where you invoking your stored procedure ) here. it would be easy to find where the error occur. also
the fields in you table? (make sure that you are not inserting null values in non-null fields)


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HELP!!! - inner exception : java.sql.SQLException: ORA-06550:
 
Similar Threads
problem while accessing stored procedure in oracle
Oracle9i wrong number or types of arguments in call to...
Can a oracle Stored procedure return a cursor as a return value?
java.sql.SQLException: Pls Help
Calling a function vs a procedure on Oracle with CallableStatement