Skip to Main Content

ORDS, SODA & JSON in the Database

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!

X-APEX-STATUS-CODE

Klaus LinhardApr 26 2013 — edited May 3 2013
Hello,

i am running the following configuration:

Oracle Database 11.2.0.3
Application Express 4.2.1
apex_listener.2.0.1.64.14.25 on Glassfish 3.01

Everything related to the restful webservices works fine. But i cannot find where to set Parameter-Alias "X-APEX-STATUS-CODE" in the new listener.


Regarding the following resource template (its an example related to the Apex Listener 1.1)

URI Template - gallery

HTTP Method - POST

Handler Type - PL/SQL Block

title Slug Header IN String
status X-APEX-STATUS-CODE Header OUT Integer
location X-APEX-FORWARD Header OUT String

declare
image_id integer;
begin
select scott.gallery_seq.nextval into image_id from dual;
insert into scott.gallery
values(image_id,:title,:contentType,:body);
:status := 201;
:location := 'gallery/' || image_id;
end;

How can i return the status (201) with the new listener because as i said, i cannot find where to set the alias as "X-APEX-STATUS-CODE"


Thanks for your help !

Kind Regards
Klaus

Edited by: Klaus Linhard on Apr 26, 2013 1:02 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2013
Added on Apr 26 2013
6 comments
3,919 views