PDA

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


D.T. Honig
03-30-2007, 10: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, 12:50 PM
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.