Copy text from web and pass it to oracle database


#1

Hi all,
I have a query where I want to copy data from web and pass it to oracle database. How to do that?


#2

Hi @Chirag1991:

Use Get Text / screen scraping / Recording - Copy Text/ Select & copy activity to grab the text from the webpage
Parse the result in a way that it is ready to be passed as a parameter to the query
Use the Database activities to send in your query

Hope it helps