Re: attention Perl master

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 http://www.fugue.com/dbi/

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

Jared

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: http://www.orafaq.com
> --
> Author: Kathy Duret
> INET: kathy.duret_at_isearch.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 ;) Received on Sun Dec 17 2000 - 21:58:06 CST