[Dbix-class] running stored procedures

[Roger Day]

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 <rabbit+dbic at rabbit.us>wro=
te:

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