Re: PL/SQL problem with oracle upgrade to 7.1.5.2.3

From: TSAWMILL.US.ORACLE.COM <TSAWMILL_at_US.ORACLE.COM>
Date: Tue, 26 Dec 1995 17:09:16 EST
Message-Id: <9512262221.AA20597@alice.jcc.com>

--Boundary-7543466-0-0

Just an off the cuff (where I spilled the gravy) idea: try just saying NULL instead of IS NULL (drop the 'IS')...

Tim Sawmiller
tsawmiller_at_us.oracle.com
"I speak for me and no else!"

--Boundary-7543466-0-0

Content-Type: message/rfc822

Date: 22 Dec 95 16:50:18
From:"Dave Hill " <HILLD_at_COUGAR.BARTON.CC.KS.US> To: Multiple,recipients,of,list,ORACLE-L,ORACLE-L_at_CCVM.SUNYSB.EDU Subject: PL/SQL problem with oracle upgrade to 7.1.5.2.3 Reply-to: ORACLE-L_at_CCVM.SUNYSB.EDU
X-Orcl-Application: Sender: "ORACLE database mailing list."  <ORACLE-L_at_CCVM.SUNYSB.EDU>
X-To: ORACLE-L_at_ccvm.sunysb.edu

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!


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

--Boundary-7543466-0-0--
Received on Tue Dec 26 1995 - 17:21:30 CST