HTTP Post XML document into Oracle RDBMS
Hey Folks,
We have a requirement to receive xml documents over http(s) and then process the contentes of those documents into oracle relational tables. The majority of the process is complete but we are using a php solution to accept the xml post over https which creates a file and then that file is loaded into an oracle xmltype table with a oracle function and and insert statement. It just seems to me that there really never needs to be a file created on the filesystem.
What would be the best method to get the xml file into the database without creating a file on the operating system? It seems that if the XMLDB would accept input from http post I'd be home free, but since it doesn't I thought Advance Queues might be the ticket!
Any help on this would be very much appreciated,
Thanks
T