Home -> Usenet -> comp.databases.oracle -> Perl DBI, Inserting CLOB data, schema owner changes

Perl DBI, Inserting CLOB data, schema owner changes

From: Christopher Boyce <cboyce45_at_yahoo.com>
Date: 19 Feb 2002 13:09:10 -0800
Message-ID: <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 Tue Feb 19 2002 - 22:09:10 CET












Original text of this message