By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
SUBSCRIBER(sub_mobileno, sub_name, sub_dob, sub_address, sub_city)
Help me with the XML code to retrieve a particular record from the target table.
Since you specifically ask about SOAP, I'll approach it from that angle.
You won't use SOAP to query a specific table for a specific row. If the other database is designed for SOAP, they can probably supply you with a URL where you can UTL_HTTP or AQ to retrieve the SOAP message.
Normally you will call a stored procedure and pass it parameters. The stored procedure will return the data.
There is a very good document for Oracle9i at http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96621/adx11soa.htm#1005578.
I don't know of any specific SOAP interfaces in Forms6i. You will probably call a stored procedure in the database and that will act as your SOAP interface. Your interface should convert your request into a SOAP message and then decode that message for you on the way out.
Check out the above link and if you have a more specific question, please post it here.
Dig Deeper on Oracle stored procedures
Related Q&A from Lewis Cunningham
How can I tell if a column is a NUMBER or VARCHAR in PL/SQL? Is there a function to do this?continue reading
I need a step-by-step procedure for importing text to an Oracle database using a stored procedure.continue reading
I need to somehow log the execution time for two procedures every time they are called and save that data (in a table?). Do you know of a way to ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.