OracleScript Bind Values
Posted: Mon 02 Oct 2006 19:19
Hi,
Is there a way to bind all values in the SQL string used by the OracleScript object?
For example
Insert into ( ) values (:pA, :pB);
Insert into ( ) values (:pA, :pB);
Insert into ( ) values (:pA, :pB);
Insert into ( ) values (:pA, :pB);
Insert into ( ) values (:pA, :pB);
Can I bing all of the values at once, or do I need to create a PL/SQL block for each one?
Best Regards
Is there a way to bind all values in the SQL string used by the OracleScript object?
For example
Insert into ( ) values (:pA, :pB);
Insert into ( ) values (:pA, :pB);
Insert into ( ) values (:pA, :pB);
Insert into ( ) values (:pA, :pB);
Insert into ( ) values (:pA, :pB);
Can I bing all of the values at once, or do I need to create a PL/SQL block for each one?
Best Regards