In the example stored procedure shown here, an INSERT INTO ...VALUES statement is used. What is the best way to conditionally filter out certain rows before (or during) the insert without affecting the performance of the array binding feature of ODP.NET?
For example, what if I don't have control over what's coming into pdeptno and pdname and I only want to insert rows where pdeptno <99? I'm thinking options might include 1) many lines of pl/sql prior to insert or 2) using an INSERT INTO... SELECT ...from dual WHERE... statement that only inserts the rows that I want. CREATE OR REPLACE PROCEDURE Test_Arraybind(pdeptno NUMBER, pdname VARCHAR2) IS BEGIN INSERT INTO depttab (deptno, dname) VALUES ( pdeptno, pdname); COMMIT; END; http://www.oracle.com/technology/sample_code/tech/windows/odpnet/howto/arraybind/index.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
