Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX_WEB_SERVICE.MAKE_REST_REQUEST giving ORA-29267: illegal call if provided with username & pwd

turuvekere_pk-OracleAug 11 2017 — edited Oct 11 2017

Hi Buddies,

I have a ws request which has basic authentication set.

First, i tried without giving username & pwd. It gave me authorisation failed. (that means i am able to hit the target url succesfully).

WS_RESPONSE := APEX_WEB_SERVICE.MAKE_REST_REQUEST

(

p_url => <target url>,

p_http_method => 'POST',

p_body => '{ field1:value1 }',

p_wallet_path => <wallet_path>,

p_wallet_pwd  => <wallet_pwd>

);

o/p :

i get html response beginning with :  <TITLE>Error 401--Unauthorized</TITLE>

Next, I am giving both userrname & pwd. BUT now it throws ORA-29267: illegal call ERROR.

WS_RESPONSE := APEX_WEB_SERVICE.MAKE_REST_REQUEST

(

p_url => <target url>,

p_http_method => 'POST',

p_body => '{ field1:value1 }',

p_username => <username>,

p_password => <pwd>,

p_wallet_path => <wallet_path>,

p_wallet_pwd  => <wallet_pwd>

);

o/p:

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1185

ORA-29267: illegal call

FYI : I am calling the API inside a stand alone procedure.

Kindly provide me some inputs on this.

Thanks,

Praveen

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 8 2017
Added on Aug 11 2017
2 comments
660 views