Hi all,
I need to import data from an other table that is only reachable via BI publisher.
BI publisher gives me a text file with data from a specific table and this file is saved in a temp table.
Now I'm writing a PLSQL procedure to format this file into inserts.
So I build a large string like this:
BEGIN
INSERT INTO TABLE (A,B,C) VALUES ('A','B','C');
INSERT INTO TABLE (A,B,C) VALUES ('A','B','C');
..
INSERT INTO TABLE (A,B,C) VALUES ('A','B','C');
INSERT INTO TABLE (A,B,C) VALUES ('A','B','C');
END;
The values in this insert i'm getting from the text file in the temp table.
This is then executed via 'EXECUTE IMMEDIATE';
This goes pretty slow probably because it is handled as single inserts.
I'm aware of the FORALL functionality but I don't know how to use it for this case because I don't have collection that can be used.
Please let me know how I can speed up this process. I hope there is a more efficient way to do these inserts than I do it now.