6 Replies Latest reply on Jul 31, 2020 7:40 PM by AndyH

X-ORDS-FORWARD-LOCATION Out parameter does not get returned in header

Geert01 Jul 29, 2020 6:08 AM

I have been trying to build the VBCS application as presented in https://blogs.oracle.com/shay/storing-image-files-in-your-database-from-a-visual-builder-app.

This is an application where a picture gets uploaded to a blob field in a table and the uploaded picture gets displayed in the application. The uploading is done via a Rest-Api call. As described in the section that is dedicated to creating the API I should add a parameter X-APEX-FORWARD. This no longer seems to be working.

According to https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/18.3/aelig/implicit-parameters.html#GUID-A5F6FF18-0…

it should be X-ORDS-FORWARD-LOCATION.

But when I change the name of the 'location' bind-variable to X-ORDS-FORWARD-LOCATION and test the API, the header of the response I get, no longer contains the 'location' value.

When I change the name of the bind variable to location I get:

But when the name is X-ORDS-FORWARD-LOCATION and I test the API, I get

I both cases the picture I upload gets uploaded to the table. So the ApI is working. Only the part of returning the location of the inserted record does not work.

But I do need the location in order to show the picture in my Application.

What am I missing?

1. Re: X-ORDS-FORWARD-LOCATION Out parameter does not get returned in header

EJ-Egyed Jul 29, 2020 12:34 PM (in response to Geert01)

X-ORDS-STATUS-CODE and X-ORDS-FORWARD-LOCATION are implicit parameters that were introduced in ORDS 18.3. Are you running ORDS version 18.3 or later? Also, they are implicit parameters so you should not be defining them as explicit parameters in your handler because they will automatically be added by ORDS.
Like Show 0 Likes(0)

Actions
2. Re: X-ORDS-FORWARD-LOCATION Out parameter does not get returned in header

Geert01 Jul 29, 2020 3:28 PM (in response to EJ-Egyed)

Should I remove these two parameters? Is that what you are saying?
Like Show 0 Likes(0)

Actions
3. Re: X-ORDS-FORWARD-LOCATION Out parameter does not get returned in header

Geert01 Jul 29, 2020 3:38 PM (in response to Geert01)

I removed the two parameters and tested the API. The result is 404 Not Found. So I guess that was not what you meant.
Like Show 0 Likes(0)

Actions
4. Re: X-ORDS-FORWARD-LOCATION Out parameter does not get returned in header

thatJeffSmith-Oracle Jul 31, 2020 6:27 PM (in response to Geert01)

Do you define a get handler for the picture?

404 sounds like the redirect is trying to pull up the picture you just uploaded, but there's no ords template/handler there to accommodate the request
Like Show 0 Likes(0)

Actions
5. Re: X-ORDS-FORWARD-LOCATION Out parameter does not get returned in header

Geert01 Jul 31, 2020 8:52 AM (in response to thatJeffSmith-Oracle)

I do not understand your question. Where do you think a get handler should be defined?
And the 404 error only occurs when I remove the two implicit parameters. So I think these implicit parameters do need to get defined in the header.
Like Show 0 Likes(0)

Actions
6. Re: X-ORDS-FORWARD-LOCATION Out parameter does not get returned in header

AndyH Jul 31, 2020 7:40 PM (in response to Geert01)

Your current REST call POSTs an image and then tells the client that it should go forward a specified location and GET.

If you re-read the page that you refer to, you will note that it says that you first need to write the GET process as the POST relies on it.
Like Show 0 Likes(0)

Actions

Go to original post