[Dbix-class] running stored procedures

Roger Day c.roger.day at gmail.com
Thu Oct 20 17:17:30 GMT 2011

No, my stored procedure does not fail on sqlplus.

It's your code that's failing. You wrap any call in a Select statement.
Select statements cannot contain semi-colons.

select * from ( Begin <some random procedure>; End;) me;

You can't have semi-colons in a middle of an embedded SQL statement.

Maybe your documentation can be a little more honest in describing what it
can, because currently, as far as I can see, and you haven't provided a
decent counter-argument, you cannot run any Oracle stored procedure from
within the result_source_instance->view_definition method.

On Thu, Oct 20, 2011 at 5:42 PM, Peter Rabbitson <rabbit+dbic at rabbit.us>wro=

> BOn Thu, Oct 20, 2011 at 04:59:24PM +0100, Roger Day wrote:
> > So it looks like the DBIx::Class code cannot run Oracle stored procedur=
> in
> > the way proscribed in the documentation? I'm not too sure that the other
> > method described would work either ...
> >
> What does this at all has to do with DBIC? You were told by 3 people and =
> oracle that your *stored proc call* is fucked. It also failed on the
> sqlplus
> cli client. So again - what kind of help can we offer you exactly?
> Cheers
> _______________________________________________
> 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/df9=

More information about the DBIx-Class mailing list