Call Stored procedure

dr.murthy · Post by **dr.murthy** » Thu Aug 30, 2012 1:12 am

Hi,

Am calling the stored procedure in the oracle enterprise stage, with in the close command option

CALL #$ESR_SCHEMA#.LOAD_UTILITIES.TRUNCATE_TABLE('HT_KNG_DIV_CLASS_LKP');

but its saying invalid close command,but this procedure is working fine when i call in oracel OCI stage in server jobs

can we call stored procedures in oracle enterprise stage

ankursaxena.2003 · Post by **ankursaxena.2003** » Thu Aug 30, 2012 12:14 pm

Why don't you try to use Stored Procedure Stage in the pallete?