Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: attention Perl master

Re: attention Perl master

From: jared still <>
Date: Sun, 17 Dec 2000 19:58:06 -0800 (PST)
Message-Id: <>

Permissions for Perl are no different than permissions for anything else. Perl DBD::Oracle uses OCI calls to do its work, so Perl is just another application as far as ORacle is concerned.

A better place to ask your question would be on the DBI users list. You can subscribe to it from the site at

Be sure to post all relevatn information: code, Perl version, DBI and DBD versions, version of Oracle and your OS version.


On Thu, 14 Dec 2000, Kathy Duret wrote:

> A co-worker wrote a perl script which inserts information into a table with
> a LOB value
> When the script is run inserting into a table which is in the user A's
> schema that runs the perl script it works fine.
> When the script is run inserting into a table which is in user B's schema
> they gets:
> DBD::Oracle::st execute failed: ORA-04043: object
> > im_queue does not exist
> > (DBD SUCCESS: OCIDescribeAny/LOB refetch)
> NOTE: the synonym for B.table is there and user A can see the table
> User A is able to insert, delete, update, etc into user's B
> table without a problem in sqlplus or other methods
> I do not want to have to hard code B.table into this script as the schema
> name can vary. Is there a way to solve this? Is there another permission I
> need
> to grant that is different for Perl?
> Kathy
> --
> Please see the official ORACLE-L FAQ:
> --
> Author: Kathy Duret
> 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: (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 ;) Received on Sun Dec 17 2000 - 21:58:06 CST

Original text of this message