[Dbix-class] running stored procedures
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=
> > 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
> cli client. So again - what kind of help can we offer you exactly?
> 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:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the DBIx-Class