Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HTTP Post XML document into Oracle RDBMS

t_grahamJan 12 2006
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2006
Added on Jan 12 2006
0 comments
700 views