Calling Function and Procedure

Hi,

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.

Your advice is greatly appreciated.

Thanks,
Modem.

Two questions -- why can't the vb side wait, and why can't you use DBMS_JOB or AQ if it can't?

Hi Dave,
Thanks for the reply. I got only 6 seconds of time to do the whole thing. Out of whcih calling and parsing cannot take more than 4 sec. DBMS_JOB and AQ are again over head on to the system.

Thanks
Modem

Have you tried using native compilation (9i) to speed up the function? I'm guessing that it is all computation, so it would benefit from that.

Hi,
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.


Thanks,
Modem

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?