Try this:
Code:create or replace package TEST_2 is wach_reversal_const CONSTANT VARCHAR2(32767) := ' s.nmr_reversal_code=''RE'''; usbw_reversal_const CONSTANT VARCHAR2(32767) := ' s.reversal_flag=''Y'''; PROCEDURE recon_1(fiid VARCHAR2, reversal_const VARCHAR2); PROCEDURE recon_2(fiid VARCHAR2); PROCEDURE recon_3(fiid VARCHAR2); end TEST_2; /![]()




Reply With Quote