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.
This was first published in August 2005