RE: ORA-904 ERROR

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 8 Jan 2001 11:23:22 -0800
Message-Id: <10735.126024@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C079A8.76ED8C80
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

> -----Original Message-----
> From: [mailto:cw_at_netlimit.com]
> Sent: lundi, 8. janvier 2001 11:09
>=20
> One of my user upgraded their oracle server from 7.2.2 to=20
> 7.3.4.5.0.  =20
> After the upgrade,  one of their package has a problem with =20
> dbms_sql.parse
> , cannot  parse data (getting error as :   ora-904  invalid=20
> column name). =20
> Any ideas?

Just a WAG, but could it be a change in column name in one of the = database
objects that the package is using?
e.g. sys.cdef$, column "type" became sys.cdef$, column "type#"

Jacques R. Kilcho=EBr
(949) 754-8816
Quest Software, Inc.

8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

------_=_NextPart_001_01C079A8.76ED8C80
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: ORA-904 ERROR</TITLE>
</HEAD>
<BODY>

> -----Original Message-----
 > From: [<A =

HREF=3D"mailto:cw_at_netlimit.com">mailto:cw_at_netlimit.com</A>]
 > Sent: lundi, 8. janvier 2001 11:09
 > 
 > One of my user upgraded their oracle server =
from 7.2.2 to 
 > 7.3.4.5.0.   
 > After the upgrade,  one of their package =
has a problem with  
 > dbms_sql.parse
 > , cannot  parse data (getting error as =
:   ora-904  invalid 
 > column name).  
 > Any ideas?

 

Just a WAG, but could it be a change in column name =
in one of the database objects that the package is using?
 e.g. sys.cdef$, column "type" became =
sys.cdef$, column "type#"


Jacques R. Kilcho=EBr
 (949) 754-8816
 Quest Software, Inc.


8001 Irvine Center Drive
 Irvine, California 92618
 U.S.A.
 <A HREF=3D"http://www.quest.com" =
TARGET=3D"_blank">http://www.quest.com</A> Received on Mon Jan 08 2001 - 13:23:22 CST