since the second parameter is is out you might try and this.
lcsql = [call proctest(?abc,?@retv)]
?SQLEXEC(gnhandle,lcsql)
?retv
>What is wrong with this code?
>
>abc=0
>retv=0
>lcsql = [call proctest(?abc,?retv)]
>?SQLEXEC(gnhandle,lcsql)
>
>Trying to pass parameters to the following stored procedure in MySQL:
>create procedure proctest(IN retv int, OUT retoutv int)
>begin
>set retoutv = -999;
>
>end
>
>What is the correct syntax, I know in MS SQL Server it works, but can't get this to work in MySQL?
>Aerror:
> 1526 ( 1526.00000000)
> ( 1, 2) C "Connectivity error: [MySQL][ODBC 5.1 Driver][mysqld-5.5.8]OUT or INOUT argument 2 for routine norco_sales.proctest is not a variable or NEW pseudo-variable in BEFORE trigger"
> ( 1, 3) C "[MySQL][ODBC 5.1 Driver][mysqld-5.5.8]OUT or INOUT argument 2 for routine norco_sales.proctest is not a variable or NEW pseudo-variable in BEFORE trigger"
> ( 1, 4) C "S1000"
>
>Any help is much appreciated.
>
>Thanks,
>Joy
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement