Oracle Forms (MOSC)

MOSC Banner

help in scripts

edited Nov 4, 2010 3:35AM in Oracle Forms (MOSC) 1 commentAnswered
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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center