Oracle-L: PL/SQL problem with oracle upgrade to 7.1.5.2.3

From: Dave Hill <HILLD_at_COUGAR.BARTON.CC.KS.US>
Date: Fri, 22 Dec 1995 16:50:18 -0500
Message-Id: <9512222319.AA07246@alice.jcc.com>

Hey, anyone want to help make my Christmas??

I have a script that is furnished by our software vendor -- worked fine under Oracle 7.0.16 with VMS 6.1.

We are now at Oracle 7.1.5.2.3 with VMS 6.2 and I am getting the following error:

DECLARE
*
ERROR at line 1:

ORA-06550: line 99, column 11:
PLS-00313: 'IS NULL' not declared in this scope
ORA-06550: line 99, column 8:

PL/SQL: Statement ignored

ORA-06550: line 131, column 11:
PLS-00313: 'IS NULL' not declared in this scope
ORA-06550: line 131, column 8:

PL/SQL: Statement ignored

The lines in question are:

       IF COL_LIST IS NULL THEN
          IF COL_TYPE IN ('DATE','NUMBER') THEN
             COL_LIST := 'TO_CHAR('||CONS_COL||')';
          ELSE
             COL_LIST := CONS_COL;
          END IF;
          COL_LIST_WHERE := '('||CONS_COL;
       ELSE
          IF COL_TYPE IN ('DATE','NUMBER') THEN
             COL_LIST := COL_LIST||',TO_CHAR('||CONS_COL||')';
          ELSE
             COL_LIST := COL_LIST||','||CONS_COL;
          END IF;
          COL_LIST_WHERE := COL_LIST_WHERE||','||CONS_COL;
       END IF;

-

and

       OPEN REF_TABLE;
       LOOP
       FETCH REF_TABLE INTO R_CONS_COL, R_TABLE;
       EXIT WHEN REF_TABLE%NOTFOUND;
       IF R_COL_LIST IS NULL THEN
          R_COL_LIST := R_CONS_COL;
       ELSE
          R_COL_LIST := R_COL_LIST||','||R_CONS_COL;
       END IF;
       END LOOP;
       CLOSE REF_TABLE;

Thanks!
Dave

Dave Hill                                   HILLD_at_cougar.barton.cc.ks.us
DBA/Systems Analyst/Programmer
BCCC, Great Bend, KS, USA  67530                A great place to work!


------------------------------------------------------------------------

Received on Fri Dec 22 1995 - 18:19:45 CST