label metadata problem
I have a store proc which goes something like this
create procedure....
main:begin
if ....
leave main
else
...
end main
Now when i get the use the metaData.getProcedureColumn for this procedure i am getting an exception
like this
java.sql.SQLException: Internal error when parsing callable statement metadata
at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1334)
at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:3640)
Now when i remove the label logic out of my store proc, things are working perfectly fine and all my input params are char. I saw in the bug history that this problem arises for parameters defined as decimals.
Thks
Subject
Views
Written By
Posted
label metadata problem
3005
November 25, 2005 12:04AM
1752
November 25, 2005 02:51AM
1629
November 25, 2005 03:17AM
1670
November 25, 2005 07:08AM
1366
November 27, 2005 11:20PM
1723
November 28, 2005 02:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.