PDA

View Full Version : Any reason StoredProcedure class will not execute an oracle function?



D.T. Honig
03-30-2007, 09:17 PM
DeriveParameters succeeds in finding the fucntion but when I execute the StoredProcedure it fails telling the procedure is not a procedure is undefined?

Any reason of the top of your head a function in oracle will not execute as a stored procedure?

Tomer
04-02-2007, 11:50 AM
There could be several reasons, can you paste-in the error code (ORA number)?
Have you tryed defining the SP prameters manualy? This should give us an idea if the problem is with the DeriveParameters mathod.