How to declare and use out parameter in powerbuilder witht ASA database
I have a stored procedure by name 'sp_getnextautono' with two arguments ( as_sequenceid Char(20), as_sequenceno double output )

In powerbuilder I have scripted as follows

//Declaration
Declare proc_autono Procedure for sp_setnextautono 
@as_sequenceid = :ls_input, 
@as_sequenceno = :ld_sequenceno;

//Execution
Execute proc_autono;

If Sqlca.Sqlcode <> 0 Then
   ls_errormsg = Sqlca.SQLErrText
   Rollback Using Sqlca;
   MessageBox( 'Error', 'Error: ' + Sqlca.SqlErrText , Stopsign! )
   Return FAILURE 
End If

// Fetch
Fetch proc_autono Into :ld_sequenceno;

If Sqlca.Sqlcode <> 0 Then
   ls_errormsg = Sqlca.SQLErrText
   Rollback Using Sqlca;
   MessageBox( 'Error', 'Error: ' + Sqlca.SqlErrText , Stopsign! )
   Return FAILURE 
End If

There is no error but I am unable to fetch the sequenceno
The variable ld_sequenceno return 0

Can anyone advice me how to solve the above issue?
How to declare and use out parameter in powerbuilder witht ASA database
===

I have a stored procedure by name 'sp_getnextautono' with two arguments ( as_sequenceid Char(20), as_sequenceno double output )

In powerbuilder I have scripted as follows

//Declaration
Declare proc_autono Procedure for sp_setnextautono 
@as_sequenceid = :ls_input, 
@as_sequenceno = :ld_sequenceno;

//Execution
Execute proc_autono;

If Sqlca.Sqlcode <> 0 Then
   ls_errormsg = Sqlca.SQLErrText
   Rollback Using Sqlca;
   MessageBox( 'Error', 'Error: ' + Sqlca.SqlErrText , Stopsign! )
   Return FAILURE 
End If

// Fetch
Fetch proc_autono Into :ld_sequenceno;

If Sqlca.Sqlcode <> 0 Then
   ls_errormsg = Sqlca.SQLErrText
   Rollback Using Sqlca;
   MessageBox( 'Error', 'Error: ' + Sqlca.SqlErrText , Stopsign! )
   Return FAILURE 
End If

There is no error but I am unable to fetch the sequenceno
The variable ld_sequenceno return 0

Can anyone advice me how to solve the above issue?