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!

apex_web_service.make_rest_request API Bug

Sergio VegaMay 26 2015 — edited May 28 2015

I think there's a bug in version 5.0 related to apex_web_service.make_rest_request. I have a code works without problems, but if I convert it into a procedure, results are wrong.

Let me explain better. The code is:

1.png

And it proceduces following output:

Status code: 200

Response: {"statistic":{"id":181574620,"event_id":24625937,"roster_id":10674551,"player_name":null,"team_id":833444,"stat_value":700.0,"calculated_total":null,"category":...................

As you can see in the response, the code was able to set a value of 700.

Now let's try similar thing but in this case using procedure as follows:

2.png

This procedure must set the value as 600, but the output is this:

Status code: 200

Response: {"statistic":{"id":181574620,"event_id":24625937,"roster_id":10674551,"player_name":null,"team_id":833444,"stat_value":700.0,"calculated_total":null,"category":....

Then, if I run the body of the procedure I got following:

Status code: 200

Response: {"statistic":{"id":181574620,"event_id":24625937,"roster_id":10674551,"player_name":null,"team_id":833444,"stat_value":600.0,"calculated_total":null,"category":

This is also happening if I convert it to a function or add it to a package.

Thanks,

Sergio

28/05/2015: Today I have tested the code and it works without problems. Not sure what was causing this.

Messaggio modificato da Sergio Vega

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 23 2015
Added on May 26 2015
0 comments
219 views