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 <[email protected]>wrote: > 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 procedures > 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 by > 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/[email protected] >
_______________________________________________ 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]
