I have a typical scenario. I have to write a function which parses a xml string and returns back if the xml is successfully parsed. After that I have to call a procedure which does some insert stuff using the XML. The Function is called by a VB component and it cannot wait untill the whole XMl is processed. What would be the best way to deal this situation by not using DBMS_JOB or AQ.
The data right now is very small but it might grow very bigger. So native compilation wont be much of hepfull for me. Is there any way that we can start a thread kind of thing in Oracle for calling the procedure.
It seems that your requirement is essentially to run the parse as fast as possible. I don't understand how any approach other than optimizing the parsing code will work -- the dbms_job, aq stuff would not speed it up at all, you just need a faster function, don't you?