Cross Origins Issue

I am not sure if CORS Requests can be solved without using plsql/block source type handler.

If you do you can write your own output response including HTTP headers and HTTP status code.

In a plsql/block source handler you can use the OWA_UTIL package to write your own header.

It allows you to add the needed headers that allow cross origin access.

Example:

  BEGIN

    ljson := '{}';

    lhttpstatuscode := 200;

    lhttpstatuscodetext := NULL;

    OWA_UTIL.STATUS_LINE(

      nstatus => lhttpstatuscode,

      creason => lhttpstatuscodetext,

      bclose_header => FALSE);

    OWA_UTIL.MIME_HEADER(

      ccontent_type => 'application/json',

      bclose_header => FALSE,

      ccharset => 'utf-8'

    );

    --headers need newline make sure to use htp.p!

    htp.p('X-My-Own-Http-Header-Here: 1234');

    htp.p('Access-Control-Allow-Origin: https://developer.mozilla.org');

    OWA_UTIL.HTTP_HEADER_CLOSE;

    --print json (important, if json is of type CLOB you need to use DBMS_LOB to loop over the CLOB

    --use htp.prn to print without newline!

    htp.prn(ljson);

  END;