EXPERT RESPONSE
You're mixing a few different things here and I'm not sure exactly
what you're looking for.
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.
|
