IDAP - WebService - AQ
- From: "Subbiah, Nagarajan" <Nagarajan.Subbiah@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 16 Feb 2006 17:03:40 -0500
Hi List,
We are at Oracle 9.2.0.5 and using IIS and .NET for the webservices. The
development team planning to use the AQ feature. Here are some questions and
I believe the answer is YES for the first two questions but don't know the
answer for the third. Can you help?
Thanks,
Raja.
1. We are planning to use Typed queues (XMLtype). However, there are
2-3 attribute values which will be populated from the CLOB fields. Since
clob size could be 32K (Microsoft .NET provider for Oracle), will the
XMLtype handle these big attributes?
2. Also, could we create a type which has attributes defined as
XMLType. then, use this type as payload.
e.g. CREATE OR REPLACE TYPE PACProgram AS OBJECT (
PAC
XMLType,
Program
XMLType);
3. How can we use IDAP to call the webservice on IIS web server from a
stored procedure (the stored procedure acting as client of the web service)?
Do we need the AQ Servlet running on the web server?
Is there any other way to call the webservice on IIS web server from a
stored procedure?
Other related posts:
