[Dbix-class] update oracle clob field fails

[Alexander Hartmaier]

Hi Marc,
are all your objects (tables, views, etc.) in the same Oracle schema?
If so you can tell Oracle to search this schema after connecting with on_co=
nnect_do ALTER SESSION SET CURRENT_SCHEMA =3D $yourschemaname

The only place where this failed for me was private database links in that =
schema.

Am 2012-02-23 17:05, schrieb Marc Logghe:
On Thu, Feb 23, 2012 at 4:37 PM, Marc Logghe <logghe.marc at gmail.com<mailto:=
logghe.marc at gmail.com>> wrote:
On Thu, Feb 23, 2012 at 4:19 PM, Marc Logghe <logghe.marc at gmail.com<mailto:=
logghe.marc at gmail.com>> wrote:


On Thu, Feb 23, 2012 at 4:15 PM, Peter Rabbitson <rabbit+dbic at rabbit.us<mai=
lto:rabbit%2Bdbic at rabbit.us>> wrote:
Which version of DBIC is this?


Hi Peter,
it's still version 0.08192, guess time for an upgrade ...

OK, upgrade seems to have fixed that weird update statement, now it looks l=
ike expected:
UPDATE anncomment SET comment_text =3D ? WHERE ( anncomment_id =3D ? )
Apologies for not upgrading first, before poking the list.

Still have an exception unfortunately:
DBI Exception: DBD::Oracle::st execute failed: ORA-04043: object anncomment=
 does not exist (DBD SUCCESS: OCIDescribeAny(view)/LOB refetch)
However, the row with the corresponding anncomment_id is definately in the =
database. I'm digging further.

Thanks !

Not sure if this is a feature or a bug.
The update is going fine when the table name is fully qualified (e.g. prefi=
xed by user/schema):
#__PACKAGE__->table("anncomment");
__PACKAGE__->table("biosql.anncomment");

Is it possible that DBIC is not (implicitely) prefixing the schema name in =
the case of update statements, but does with searches ? Searching seems to =
work without explicitely added prefix.
Cheers,
Marc




_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co=
.uk


*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*=
"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*=
"*
Notice: This e-mail contains information that is confidential and may be pr=
ivileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*=
"*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120223/c34=
d6e0c/attachment.htm