StoredProc




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.











( storedproc.html )- by Paolo Puglisi - Modifica del 17/12/2023