web services and oracle
-
Hi, im having a problem when i call a web service using a stored procedure in oracle. I download from a wep page an api that let me interact and this is my stored procedure: PROCEDURE consultar () IS --DECLARE l_request Soap_Api.t_request; l_response Soap_Api.t_response; l_tipocambio NUMBER; BEGIN --UTL_HTTP.set_proxy('bart.tshcomputing.com:4480', NULL); --UTL_HTTP.set_persistent_conn_support(TRUE); l_request := Soap_Api.new_request(p_method => 'ConsultarTC', p_namespace => 'xmlns="http://tempuri.org/"'); l_response := Soap_Api.invoke(p_request => l_request, p_url=> 'http://10.32.1.56/webserviceia/tipocambio.asmx',--c_url_webservice, p_action => 'http://tempuri.org/ConsultarTC'); l_tipocambio := Soap_Api.get_return_value(p_response => l_response, p_name => 'Compra', p_namespace =>'http://tempuri.org/'); DBMS_OUTPUT.put_line(' l_Compra:' || l_tipocambio); bDisponible := TRUE; EXCEPTION WHEN NO_DATA_FOUND THEN NULL; WHEN OTHERS THEN RAISE; END consultar; i having the next error: Server was unable to read request. --> 'Text' is an invalid node type. Line 1, position 170. can anybody help me? or where can i find examples and trust documentation of this?? thanks!!