MySQL Forums
Forum List  »  Stored Procedures

label metadata problem
Posted by: Srivats Chandrasekaran
Date: November 25, 2005 12:04AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
label metadata problem
2826
November 25, 2005 12:04AM
1670
November 25, 2005 02:51AM
1534
November 25, 2005 03:17AM
1570
November 25, 2005 07:08AM
1270
November 27, 2005 11:20PM
1629
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.