Use Name Parameters With Oracle Stored Procedures

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: