tag:blogger.com,1999:blog-5215551487816981140.post1905535936472058955..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: Calling a SOAP web service from PL/SQL by extending the FLEX_WS_APIMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5215551487816981140.post-65269886559826303312013-05-17T00:40:08.823-07:002013-05-17T00:40:08.823-07:00@Piotr: Do you have Apex 4 installed in your datab...@Piotr: Do you have Apex 4 installed in your database? If so, please try out APEX_WEB_SERVICE.MAKE_REQUEST and pass the p_wallet_path and p_wallet_pwd parameters to do a call to an https site.<br /><br />See http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21676/apex_web_service.htm#BABEEICD for more info.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-21095830118649111582013-05-16T10:51:06.774-07:002013-05-16T10:51:06.774-07:00Dear mr Braten,
Could please help me out. I am tr...Dear mr Braten,<br /><br />Could please help me out. I am trying to use the FLEX_WS_API for calling a SOAP service using certificates. I have created a wallet using the wallet manager. However, I have to deal with a root certificate and a system certificate. These certificates are used for authentication. When using the ewallet.p12 in the tool soapui I get a valid response. But when using the command UTL_HTTP.set_wallet and then other UTL_HTTP commands I get "validation certificate failed". I am using oracle 10.2 on Windows. Can you please help me out?Anonymoushttps://www.blogger.com/profile/05171015351900902373noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-56415572730453446812010-02-24T05:23:49.287-08:002010-02-24T05:23:49.287-08:00hmmm, it looks like my xml got hidden by the brows...hmmm, it looks like my xml got hidden by the browser - here it is again using [] instead of < ><br />----><br />When the response node contains single instances of each sub-node it works fine. However, one of my web services returns sub-node values that contain repeated sub-nodes i.e. an array of values<br />e.g.<br /> [ApplicationsReponse]<br /> [ApplicationsResult]<br /> [string][/string]<br /> [string][/string]<br /> [string][/string]<br /> [/ApplicationsResult]<br /> [/ApplicationsReponse]<br /><br />At the moment, flex_ws_util.get_value() returns null when I pass it 'ApplicationsResult' as p_name, rather than the '[string][/string][str...' value as I'd expect.<br /><br />How do I extract the [string] values? (at the moment I parse the entire returned XML using TABLE(XMLSEQUENCE(EXTRACT( )Richardnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-13697135635464578982010-02-24T05:21:32.871-08:002010-02-24T05:21:32.871-08:00Thanks for this, it works brilliantly. I have impl...Thanks for this, it works brilliantly. I have implemented it and now use it with a user validation solution (a kind of 'SSO-lite').<br /><br />When the response node contains single instances of each sub-node it works fine. However, one of my web services returns sub-node values that contain repeated sub-nodes i.e. an array of values<br />e.g.<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /><br />At the moment, flex_ws_util.get_value() returns null when I pass it 'ApplicationsResult' as p_name, rather than the ' values? (at the moment I parse the entire returned XML using TABLE(XMLSEQUENCE(EXTRACT( )<br /><br />Thanks again,<br />RIchardRichardnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-75922540777376555612009-10-23T06:50:05.678-07:002009-10-23T06:50:05.678-07:00@Anonymous:
The main difference is that the utl_d...@Anonymous:<br /><br />The main difference is that the utl_dbws package is a wrapper for Java code, while the flex_ws_api package and my companion t_soap_envelope type are written in PL/SQL.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/16506692325808919895noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-80413565386317756962009-10-08T08:45:01.638-07:002009-10-08T08:45:01.638-07:00How does this differ from the built-in utl_dbws pa...How does this differ from the built-in utl_dbws package?<br /><br />http://www.oracle-base.com/articles/10g/utl_dbws10g.phpAnonymousnoreply@blogger.com