Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PL/SQL problem with oracle upgrade to 7.1.5.2.3

Re: PL/SQL problem with oracle upgrade to 7.1.5.2.3

From: Umesh K. Tiwari <utiwari_at_IX.NETCOM.COM>
Date: Tue, 26 Dec 1995 19:51:30 -0800
Message-Id: <9512270410.AA31463@alice.jcc.com>


You wrote:

Try using NVL function, assign some value for null (say 0) and use > or < symbol for your condition, that helps sometimes.... good luck!

Umesh
>
>--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 - 23:11:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US