Database Software

Hello,

I can't get data from XMLsequence into a CLOB using getClobVal().
With the code below I get this error:
---
The following error has occurred:

ORA-06550: line 7, column 17: [the getClobVal() statement]
PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER got CLOB
ORA-06550: line 7, column 1:
PL/SQL: SQL Statement ignored
---
xml_t is defined like this: create or replace type xml_t is VARRAY (2000) of CLOB
OMWB_cv1 is a weak ref cursor (created for my stored procedure by the Oracle Migration Workbench)

I want to use XMLSequence to extract the query as XML snippets, and then I'll aggregate them together in a single CLOB. Any ideas on how to accomplish this without the need to explicitly list out the individual columns would be appreciated, since I need to perform this same operation on 125 stored procedures and would rather write a wrapper than rewrite each one. Thanks.

Richard Sonnenblick
rich@enrich***consulting.com (remove *** for email address)

---
declare
OMWB_cv1 OMWB_emulation.globalPkg.RCT1;
xml_series xml_t;
begin
sa.getallprojectswithsnapshots(OMWB_cv1);

SELECT value(e).getClobval() INTO xml_series
FROM TABLE(XMLSequence(OMWB_cv1)) e;

end;