TOraStoredProc.Overload not working

craigjones · Post by **craigjones** » Tue 06 Jun 2006 21:48

I'm using ToraStoredProc to call an overloaded stored proc with 2 parameters (Float/In). I specified Overload = 2 in the DFM, yet I get the following Oracle error:

ORA-06550: line 2, column 3:
PLS-00307: too many declarations of 'RELEASE_PICK_LOT' match this call
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

Isn't that what the overload property is supposed to resolve? What am I doing wrong?

Plash · Post by **Plash** » Thu 08 Jun 2006 09:41

TOraStoredProc component uses Overload property to create PL/SQL call to stored procedure and to create parameters. But if in your package there is more than one overloaded procedure that can be called with such parameters error will be raised. You should alter your package so that only one overload of procedure RELEASE_PICK_LOT can be called with two parameters of type Float.