Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

problem in calling of stored procedure with variable parameters

Hello!

When we try to call our stored procudure with variable parameter (year and month) we receive various errors.

Here's the dynamic package script code:

DEBUG(ON)

PROMPT(SELECTINPUT,,,"Please select time for restatement",%TIME_DIM%)

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,APPSET,%APPSET%)

TASK(Execute formulas,APP,%APP%)

TASK(Execute formulas,SELECTION,%SELECTIONFILE%)

TASK(Execute formulas,LOGICFILE,%APPPATH%\..\AdminApp\%APP%\zbpc_to_fm.lgx)

TASK(Execute formulas,RUNMODE,1)

TASK(Execute formulas,LOGICMODE,1)

TASK(Execute formulas,SIMULATION,1)

TASK(Execute formulas,CHECKLCK,0)

Our logic script file (zbpc_to_fm.lgx) code is:

*RUN_STORED_PROCEDURE=ztest('%TIME_SET%')

*commit

The problem occures while transferring the variable parameter %TIME_SET% value.

How can we correctly transfer the selected value of TIME_SET into the procedure?

Former Member
Not what you were looking for? View more on this topic or Ask a question