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
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
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