NDS vs DBMS_SQL

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

.

Relevant Pages

  • Re: NDS vs DBMS_SQL
    ... I have an application in which i have to serialize an C++ object in ... Oracle DB. ... So i am serializing the object as XML file and storing it in XML ... From there i am parsing the XML and based on the tablename ...
    (comp.databases.oracle.server)
  • Re: Serialization Question
    ... Note that this option can get tricky, as you are going to return an XML string from the web service method, which may not work for them. ... Create another object that has the clients format and transfer the information from your object to that object when the web routine that this client uses is hit. ... The only reason I can see is you are trying to serialize this information and present it, via some sort of service boundary, as XML, not as a serialized object. ... I would take the XML through a transformation to get the format you desire rather than attempt to have the object serialize differently. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Regarding performance on objects serialized to Xml - thoughts and code presented
    ... instance and add the XML to that. ... > StringWriter sW = new StringWriter; ... > XmlTextWriter XmlW = Xml.XmlTextWriter;> ... > // Serialize PlaceHolders ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Serialization Question
    ... files to a partner organisation and they are expecting an XML file of the ... The only reason I can see is you are trying to serialize this information ... If I had Address as Array(of String) then all parts of address would have ... How could I change things so the the XML file produced is of this format: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: DataSet and best practice in 2.0
    ... from webservices to remoting no? ... which changes the whole game for distributed apps. ... Collections serialize to XML as well so there's not that much ...
    (microsoft.public.dotnet.framework.performance)