Re: Perl DBI, Inserting CLOB data, schema owner changes

Forgot to add:

create table test (
  blah VARCHAR2(64),
  blah_clob CLOB
);

synomyn has been added for test

Some Insert.....

Error Message when user connecting to database is no the schmea owner, and yes I am doing my binds correctly. It works fine when you connect to the database as the schema owner.

ORA-04043: object test does not exist (DBD SUCCESS: OCIDescribeAny(view)/LOB refetch)

DBD-Oracle-1.12
DBI-1.21
Oracle 8.1.7.2.0
Solaris 8

Thanks again,

Chris

cboyce45_at_yahoo.com (Christopher Boyce) wrote in message news:<c67657ff.0202191309.203cae0b_at_posting.google.com>...
> Hello Oracle Group:
>
> I have a question for any of the Oracle DBA's out there. I am
> connecting through the Perl DBI to push data into a table that has a
> CLOB(s) column. This works fine when I connect as the schema owner,
> but when I connect as a user that has been granted access to the
> schema in which synonyms have been created, I get all of the data
> except the CLOB data. Are there any special grants or resources that
> need to be given to the later user or on the tables/columns?
>
> Thanks for any help,
>
> Chris
Received on Wed Feb 20 2002 - 21:24:25 CET