Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re^3: Execute Oracle Stored procedure using DBIx::ProcedureCall

by afoken (Abbot)
on Dec 23, 2009 at 14:15 UTC ( #814099=note: print w/replies, xml ) Need Help??

in reply to Re^2: Execute Oracle Stored procedure using DBIx::ProcedureCall
in thread Execute Oracle Stored procedure using DBIx::ProcedureCall

Here is the Oracle procedure I'm trying to execute [...] create or replace PROCEDURE abc AS [...]

This is a PROCEDURE. In your first posting starting this thread, you tried to call it as a FUNCTION.

A FUNCTION is something else than a PROCEDURE. Functions must return values, procedures can not return anything. Assigning (or comparing) "the result" of a procedure is impossible, as there is no result, and there can't be one.

something:=someProcedure is invalid, Oracle told you that, and the Google results for "PLS-00222" would have told you that even more clearly. (And I told you that pretty clear, too.)


Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://814099]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (3)
As of 2017-12-17 05:06 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (462 votes). Check out past polls.