procedure pre_decre_calc_clbal is
c number;
lcnt number(5);
lcnt1 number;
l_msg varchar2(200);
l_mob varchar2(15);
type string_array is table of varchar2(100)index by binary_integer;

  MSC_ID        VARCHAR2(20 ),
  PLAN_ID    VARCHAR2(20 ),
  ACT_DATE   DATE,
  DUM        VARCHAR2(5 ),
  PADJ       NUMBER(10,2));

2)
CREATE TABLE TMP_ADJ
(
  MSC_ID               NUMBER(20),
  NOMINALAMOUNT         NUMBER(20))

I have to comepare MSC_ID and update the Nominalamount in table1 (PADJ)column

SET SERVEROUTPUT ON;

DECLARE

i number;

CURSOR NLD IS
SELECT A.ROWID AS TMP_ROWID,A.* FROM CHN_BILLREFDUMP3_T1_FX A WHERE A.STAT=0 AND A.STRM=1;


BEGIN

i:= 0;

FOR CC IN NLD LOOP

DELETE FROM CHN_BED3A_T4_FX ;