I need some help.
I have a third party java API to search a Stock Database
An example of how I would do this is:
String query = "Light Bulb";
QueryBuilder builder = new QueryEngine("stockSearch")
org.jdom.Document searchResult = Builder.search(query);
The search results come back as an XML org.jdom.document
<description>40w Light Bulb</Description>
<description>60w Light Bulb</Description>
What i need to know is how to execute the api from PL/SQL
and get the result into a temporary table in oracle.
So? Do i need to get the third party API into that database with loadjava?
What is the PLSQL to be able to pass a search string?
And how do i get the resultant document in to the db.
Alternatively the resulting document can be generated with http
and returns the same xml document
Would that be simpler to execute in the database?
I know there is a lot, but all all help is appreciated