APEX

Hi All

I could do with some assistance getting Web service's up & running on my application
I've been following this guide but altering to fit in with our internal web services... the Internet police here at work have youtube blocked off so unable to test end to end using the OTN tutorial

I've created a web service named PASSWORDGEN with the results stored in the collection PASSWORDRESULT

On my page I've created the process that invokes the webservice PASSWORDGEN which is set to run on load - before header - seq #10

then created the pl/sql anonymous block process which is set to run on load - before header - seq #20

I've used the pl/sql example given in the tutorial but substituted their references to collections with my named collection .


declare
l_clob clob;
l_xml xmltype;
l_val clob;
begin
for c1 in (select clob001
from apex_collections
where collection_name = 'PASSWORDRESULT'
) loop
l_clob := c1.clob001;
exit;
end loop;
l_xml := xmltype.createxml(l_clob);
l_val := dbms_xmlgen.convert(l_xml.extract('/methodResponse/params/param/value/string/text()').getclobval(),1);
apex_collection.update_member_attribute(
p_collection_name => 'PASSWORDRESULT',
p_seq => '1',
p_clob_number => '1',
p_clob_value => l_val );
end;


if I try to run the page at this point I get the error ORA-30625: method dispatch on NULL SELF argument is disallowed


what I think is happening, from what I've read up on, is that the collection is empty?

so I'm trying to find out if the web service is not populating the collection correctly or have I made a mistake in the above syntax & trying to reference the collection incorrectly.

Is there a way I can query the collection using TOAD?

Edited by: Mr JD on 21-Jul-2010 08:38