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. |