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?
TIA
Roger
_______________________________________________
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]
