From daemon Fri Dec 22 18:19:45 1995 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA07246; Fri, 22 Dec 1995 18:19:42 -0500 Message-Id: <9512222319.AA07246@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 1444; Fri, 22 Dec 95 17:53:35 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 0646; Fri, 22 Dec 1995 17:53:32 -0500 Date: Fri, 22 Dec 1995 16:50:18 -0500 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Dave Hill Subject: PL/SQL problem with oracle upgrade to 7.1.5.2.3 X-To: ORACLE-L@ccvm.sunysb.edu To: Multiple recipients of list ORACLE-L 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@cougar.barton.cc.ks.us DBA/Systems Analyst/Programmer BCCC, Great Bend, KS, USA 67530 A great place to work! ------------------------------------------------------------------------