A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
HELP!!! - inner exception : java.sql.SQLException: ORA-06550:
Joined: Jan 14, 2004
Jan 22, 2007 22:04:00
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 :
: ORA-06550: line 1, column 7:
Can you please help!!
Thanks in advance
SCJP , SCWCD , SCBCD , SCDJWS
Joined: Dec 06, 2005
Jan 23, 2007 00:37:00
can you post your Stored Procedure and
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)
How To Ask Questions On JavaRanch
I agree. Here's the link:
subject: HELP!!! - inner exception : java.sql.SQLException: ORA-06550:
problem while accessing stored procedure in oracle
java.sql.SQLException: Pls Help
Oracle9i wrong number or types of arguments in call to...
Can a oracle Stored procedure return a cursor as a return value?
Calling a function vs a procedure on Oracle with CallableStatement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014