• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

how to insert RSS feed into an oracle 10 table

I want to know the best way to take an rss feed and insert it into an oracle table.  What is the best way to do this?  Can it be done?  Anyway to make it realtime transactions?
0
kfeiner
Asked:
kfeiner
  • 2
2 Solutions
 
MikeOM_DBACommented:

How do you capture this RSS feed?
Once your application that captures the feed has it in some memory location, just have it insert the data into a table with BLOB column.



0
 
kfeinerAuthor Commented:
right.. but what is the best way to capture it... cuz i dont think that oracle can grab the xml directly from an http call with pl/sql.  i might have to use php to collect the data and push it into oracle.  any thoughts?
0
 
MikeOM_DBACommented:
Yes, this is more of an application issue, once you capture the xml you can use any of Oracle xml functionality to "stick it in" the database.
 
 
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now