Getting error when calling Stored Procedure in script

[vas_y]

Hi,

I am getting an error on while executing stored procedure on oracle 11g db as source by calling below in the script BODS 4.1.

sql( 'ds_xxx','begin schemaxxx.PAC_xxx_LOAD.PRC_xxx;end;');

sql( 'ds_xxx','begin schemaxxx.PAC_xxx_LOAD.PRC_xxx;end;');

sql( 'ds_xxx','begin schemaxxx.PAC_xxx_LOAD.PRC_xxx;end;');

Steps:

1. Imported SP into functions

2. Called stored procedure in script

Error:

1st SP is executing correctly and when it executes 2nd and 3rd SP, am getting below error.

I would appreciate your help on this.

[Former Member · Accepted solution]

Try adding "()" to end of the function call

sql( 'ds_xxx','begin schemaxxx.PAC_xxx_LOAD.PRC_xxx(); end;');

Cheers

Scott

[vas_y · Accepted solution]

Thanks Scott for quick response. I came to know that, 1st SP will call other SP while executing and shouldn't run all procedure at same time that's why I am getting error for 2nd and 3rd SP.

However, 1st SP is executing without '()' at end of the function call.

I really appreciated your quick help.

Thanks,

Sri