When executing an Oracle stored procedure, use the named parameter convention. In place of this code:
OraDatabase.ExecuteSQL _ ("Begin Employee.GetEmpName (:EMPNO, :ENAME); end;") Use this code:OraDatabase.ExecuteSQL ("Begin Employee.GetEmpName _ (empno=>:EMPNO, ename=>:ENAME); end;")
The second example still works even if you change the positions of the stored-procedure arguments. Also, with this convention, you can write a generic routine to assemble the SQL statement without worrying about positioning the stored-procedure arguments.