-
Charlie Cummins
- PowerBuilder
- Friday, 14 February 2020 09:51 PM UTC
Hello,
Running PB 2017 R3, using ODBC to connect to ASE database.
PB in-code stored procedures declares are failing on recompile the with following error (ran fine under ASE Native). C0038: SQLSTATE = ZZZZZ[SAP][ASE ODBC Driver][Adaptive Server Enterprise]Must declare variable '@ll_rv.
Here is PB Code in question.
TRANSACTION ltr_transobj
integer li_rc
long ll_rv, ll_beg_ckno, ll_end_ckno
integer li_subsystem
string ls_batchid
string ls_result
////////////////////////////////////////////////////////////////
//======================================================================
ltr_transobj = THIS.of_get_transobj()
li_rc = 1
THIS.of_set_strerr_method( THIS.ClassName() + ".of_dbsp_isvalid_ckrng()" )
//======================================================================
//======================================================================// check transaction object
IF IsValid( ltr_transobj ) THEN
ELSE
// MessageBox( THIS.ClassName(), "Invalid Transaction Object, Contact IS.", StopSign!)
THIS.of_set_strerr_successful( FALSE )
THIS.of_set_strerr_error_code( -1 )
THIS.of_set_strerr_error_type( "System Error, Powerbuider" )
THIS.of_set_strerr_error_message( "Invalid Transaction Object, Contact IS." )
// return error structure
RETURN istr_error
END IF
//======================================================================
//======================================================================
// assign passed parameters
li_subsystem = ai_subsystem
ls_batchid = as_batchid
ll_beg_ckno = al_beg_ckno
ll_end_ckno = al_end_ckno
//======================================================================
DECLARE lspcp_valid_ckrng PROCEDURE FOR @ll_rv = spcp_valid_ckrng
@int_subsystem = :li_subsystem,
@c_ckbatchid = :ls_batchid,
@int_ckbegno = :ll_beg_ckno,
@int_ckendno = :ll_end_ckno
USING ltr_transobj;
//======================================================================
Maybe its just a ODBC setting or Declare syntax change?
Thanks for your help, Charlie
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.