It's DBIC (possibly, but not I thnik likely) that I think is creating the superfluous <*>, as it is creating the wrapper around the original piece of SQL - which I give below as well.
I'm trying to invoke a stored procedure with no arguments. I just need to poke it to try and stop the friendly software from being over helpful. On Thu, Oct 20, 2011 at 1:02 PM, Peter Rabbitson <[email protected]>wrote: > On Thu, Oct 20, 2011 at 11:01:25AM +0100, Roger Day wrote: > > Hi > > I'm trying to run stored procedures through DBIx::Class and I get this > > problem: > > > > DBI Exception: DBD::Oracle::db prepare_cached failed: ORA-00907: missing > > right parenthesis (DBD ERROR: error possibly near <*> indicator at char > 49 > > in 'SELECT * FROM ( > > BEGIN > > CreateTemporaryTables<*>(); > > END; > > ) me ') [for Statement "SELECT * FROM ( > > BEGIN > > CreateTemporaryTables(); > > END; > > ) me " > > > > Code is as follows: > > > > package DSTI::CPP::Schema::Result::CreateTemporaryTables; > > use base qw/DBIx::Class::Core/; > > __PACKAGE__->table_class('DBIx::Class::ResultSource::View'); > > > > __PACKAGE__->table('USER_TABLES'); > > > > __PACKAGE__->result_source_instance->is_virtual(1); > > > > __PACKAGE__->result_source_instance->view_definition(q[ > > BEGIN > > CreateTemporaryTables(); > > END; > > ]); > > 1; > > __EOF__ > > > > and I call it thus: > > > > $handle->resultset('CreateTemporaryTables')->all; > > > > The procedure has no arguments to pass ... just what am I doing wrong? > > > > It looks like your stored proce call is malformed. Run the same sql via > $schema->storage->dbh_do(sub { $_[1]->selectall_hashref($sql) }) to get > DBIC > out of the picture. I suspect the error will be identical. > > > _______________________________________________ > 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] >
_______________________________________________ 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]
