Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> IDAP - WebService - AQ

IDAP - WebService - AQ

From: Subbiah, Nagarajan <Nagarajan.Subbiah_at_aetn.com>
Date: Thu, 16 Feb 2006 17:03:40 -0500
Message-ID: <30462D80AA52E74698512ADCC4F7EAA32D74C80A@exchange.aetvn.com>


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?
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 16 2006 - 16:03:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US