Calling Function and Procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Calling Function and Procedure

  1. #1
    Join Date
    Jan 2002
    Posts
    17

    Question 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.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Two questions -- why can't the vb side wait, and why can't you use DBMS_JOB or AQ if it can't?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2002
    Posts
    17

    Calling Function and Procedure

    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

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Jan 2002
    Posts
    17

    Calling Function and Procedure

    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

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width