All,
I have an application in which i have to serialize an C++ object in
Oracle DB. This object has 100 properties and all properties have to be
stored in different tables. These properties can be added/deleted at
client side.
So i am serializing the object as XML file and storing it in XML
repositorty. From there i am parsing the XML and based on the tablename
creating a dynamic query for inserting. SOmething like:
FORALL index in 1..PropCount
EXECUTE IMMEDIATE ' INSERT INTO '||tblname||'(val) VALUES (:a)' USING
t_char(index);

So this is hampering the performance as this statement has to be parsed
evrytime.
Is there a better way to update tables (when the tablenames are
dynamic) ? I want to do away with hard parse here.
I tried using DBMS_SQL but there are limitations in that (like varchar2
is 2000).

Pls suggest.

TIA
S