Well, duh! ( slapping forehead )
I guess that's what the 'OCIDescribeAny/LOB' message means
Jared
On Tue, 1 Aug 2000, [iso-8859-1] paquette stephane wrote:
> It's not a problem with perl but a problem with OCI.
> There are 2 bugs related to that problem,
> it seems that the OCIDescribeAny call doesn't resolve
> public synonym correctly.
>=20
> I have a TAR opened on this.
> The current workaround is to prefix the table_name
> with the owner.
>=20
>=20
> --- Jared Still <jkstill_at_bcbso.com> a =E9crit=A0: >=20
> > Try the DBI mailing lists. More info at:
> >=20
> >
> http://www.isc.org/services/public/lists/dbi-lists.html
> >=20
> > Jared
> >=20
> > On Fri, 28 Jul 2000, [iso-8859-1] paquette stephane
> > wrote:
> >=20
> > > A developper has a strange error :=20
> > > ORA-04043: object mlr_mail_defn does not exist
> > (DBD
> > > SUCCESS: OCIDescribeAny/LOB refetch).
> > >=20
> > > The mlr_mail_defn table has a clob field.
> > >=20
> > > With the develloper account, I'm able to
> > select/insert
> > > without problem with sqlplus.
> > >=20
> > > The same developper is able to work on another
> > table
> > > containing a clob without problem using perl .
> > >=20
> > > Anybody ?
> > >=20
> > >=20
> > > =3D=3D=3D=3D=3D
> > > Stephane Paquette
> > > DBA Oracle
> > > stephane_paquette_at_yahoo.com
> > > spaquette_at_houra.fr
> > > (33) 01 53 93 06 50
> > >=20
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Kick off your party with Yahoo! Invites.
> > > http://invites.yahoo.com/
> > > --=20
> > > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> > > INET: stephane_paquette_at_yahoo.com
> > >=20
> > > Fat City Network Services -- (858) 538-5051=20
> > FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> > access / Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from). You may
> > > also send the HELP command for other information
> > (like subscribing).
> > >=20
> >=20
> >=20
> > Jared Still
> > Certified Oracle DBA and Part Time Perl Evangelist=20
> > ;-)
> > Regence BlueCross BlueShield of Oregon
> > jkstill_at_bcbso.com - Work - preferred address
> > jkstill_at_teleport.com - private
> >=20
> >=20
>=20
>=20
> =3D=3D=3D=3D=3D
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>=20
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
> --=20
> Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> INET: stephane_paquette_at_yahoo.com
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>=20
Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-)
Regence BlueCross BlueShield of Oregon
Received on Wed Aug 02 2000 - 18:55:35 CDT