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_connect_do ALTER SESSION SET CURRENT_SCHEMA = $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 <[email protected]<mailto:[email protected]>> wrote: On Thu, Feb 23, 2012 at 4:19 PM, Marc Logghe <[email protected]<mailto:[email protected]>> wrote: On Thu, Feb 23, 2012 at 4:15 PM, Peter Rabbitson <[email protected]<mailto:rabbit%[email protected]>> 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 like expected: UPDATE anncomment SET comment_text = ? WHERE ( anncomment_id = ? ) 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. prefixed 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/[email protected] *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* 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 privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________ 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/[email protected]
