Oveloaded functions
Oveloaded functions
Is it possible to call overloaded functions in OraDeveloper Studio and dotConnect for Oracle? For example there are two functions with the same name "INS" but with different parameters
We recommend setting the exact number of procedure overload after the name of the procedure in the CommandText property (the number of overload is determined by the order of the procedure creation in the package).
E.g., use
command.CommandText = "PACKAGE_NAME.PROCEDURE_NAME:2";
instead of
command.CommandText = "PACKAGE_NAME.PROCEDURE_NAME";
You can see the number of overload you need using the design time component OracleCommand: drag&drop this component on Form Designer > select its CommandText property > set Type to StoredProcedure and choose one of the available overloads in the Object Name drop-down list, then navigate to the Parameters tab, confirm regeneration of the Parameters collection, and you can determine in this way which overload the selected number of overload corresponds to.
E.g., use
command.CommandText = "PACKAGE_NAME.PROCEDURE_NAME:2";
instead of
command.CommandText = "PACKAGE_NAME.PROCEDURE_NAME";
You can see the number of overload you need using the design time component OracleCommand: drag&drop this component on Form Designer > select its CommandText property > set Type to StoredProcedure and choose one of the available overloads in the Object Name drop-down list, then navigate to the Parameters tab, confirm regeneration of the Parameters collection, and you can determine in this way which overload the selected number of overload corresponds to.