Solved

how to insert RSS feed into an oracle 10 table

Posted on 2009-05-07
3
357 Views
Last Modified: 2013-12-18
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
Comment
Question by:kfeiner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 24387976

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
 

Author Comment

by:kfeiner
ID: 24388016
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
 
LVL 29

Assisted Solution

by:MikeOM_DBA
MikeOM_DBA earned 500 total points
ID: 24388094
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question