help in scripts
hi,
i have been working on this form with a revised script, but seems I've encountered errors in highlighted part which says
Encountered the symbol "=" when expecting one of the following:
:=.[@%;
Any tips guys...
Heres my script in the form.
DECLARE
CURSOR C1 IS
SELECT COUNT(*) TOT_COUNT
FROM sbis.bayadcenter b;
CURSOR C IS
SELECT b.cisi,b.dep_date,b.branch,b.drn_no,b.chk_no,b.chk_amt
FROM sbis.bayadcenter b
where b.dep_date= :cgtemp.dep_date;
CREC C%ROWTYPE;
C1REC C1%ROWTYPE;
out_file TEXT_IO.FILE_TYPE;
txt_file VARCHAR2(30) := :cgtemp.FILENAME;
Encountered the symbol "=" when expecting one of the following:
:=.[@%;
Any tips guys...
Heres my script in the form.
DECLARE
CURSOR C1 IS
SELECT COUNT(*) TOT_COUNT
FROM sbis.bayadcenter b;
CURSOR C IS
SELECT b.cisi,b.dep_date,b.branch,b.drn_no,b.chk_no,b.chk_amt
FROM sbis.bayadcenter b
where b.dep_date= :cgtemp.dep_date;
CREC C%ROWTYPE;
C1REC C1%ROWTYPE;
out_file TEXT_IO.FILE_TYPE;
txt_file VARCHAR2(30) := :cgtemp.FILENAME;
0