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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only