Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Florida
    Posts
    6

    Unanswered: Insert into MySQL from PL/SQL. I know, sounds weird.

    Hi,

    I have this particular scenario:
    I am developing a website in PHP/MySQL.
    I need to to http_request some data and insert into respective fields in tables.
    The only way I know for that is using PL/SQL. But I want the final data to be in my MySQL database.

    Any ideas?
    thank you.
    -- PDR

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    >I need to to http_request some data and insert into respective fields in tables.

    What kind of data are you talking about? Built in Global variables? Can you use the $globals key word to extract the variables you want and use them in the table and write to mysql DB?

    .
    ~

    Bill

  3. #3
    Join Date
    Feb 2004
    Location
    Florida
    Posts
    6
    I want to use Oracle's HTTP requests found using package UTL_HTTP
    and grab data from a webpage, parse it, and insert into a MySQL database.

    any ideas how to talk to MySQL from PL/SQL for that approach?

Posting Permissions

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