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.
I have a TAR opened on this.
The current workaround is to prefix the table_name
with the owner.
- Jared Still <jkstill_at_bcbso.com> a écrit : >
> Try the DBI mailing lists. More info at:
>
>
http://www.isc.org/services/public/lists/dbi-lists.html
>
> Jared
>
> On Fri, 28 Jul 2000, [iso-8859-1] paquette stephane
> wrote:
>
> > A developper has a strange error :
> > ORA-04043: object mlr_mail_defn does not exist
> (DBD
> > SUCCESS: OCIDescribeAny/LOB refetch).
> >
> > The mlr_mail_defn table has a clob field.
> >
> > With the develloper account, I'm able to
> select/insert
> > without problem with sqlplus.
> >
> > The same developper is able to work on another
> table
> > containing a clob without problem using perl .
> >
> > Anybody ?
> >
> >
> > =====
> > Stephane Paquette
> > DBA Oracle
> > stephane_paquette_at_yahoo.com
> > spaquette_at_houra.fr
> > (33) 01 53 93 06 50
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Kick off your party with Yahoo! Invites.
> > http://invites.yahoo.com/
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> > INET: stephane_paquette_at_yahoo.com
> >
> > 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).
> >
>
>
> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist
> ;-)
> Regence BlueCross BlueShield of Oregon
> jkstill_at_bcbso.com - Work - preferred address
> jkstill_at_teleport.com - private
>
>
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Tue Aug 01 2000 - 08:30:36 CDT
