4 Replies Latest reply: Nov 23, 2012 9:36 AM by odie_63 RSS

    Report fail or success to table after insert from external table

    973769
      Hi All,

      Hope someone can help me with this:

      Let me tell what the current situation is:

      1. XML file inserted into temporary xml table by using external table
      2. XML data inserted into table_1 so that the xml info is in a 'normal' oracle table
      3. insert into...select into a table from the table in 2 where 2 values are not present via a 'where not exists' clause
      4. if the values are present, an entry must be made to another table with the reason
      5. if the values are not present, an entry must be made to another table with the reason

      Thanks in advance!

      Edited by: user6357028 on 23-Nov-2012 01:16