[Dbix-class] running stored procedures

[Roger Day]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20111020/43b=
77ea0/attachment.htm