0 Replies Latest reply on Feb 6, 2019 11:36 AM by study-feng

    pleae teach how to access DB procedure by ORDS(no APEX installed)?

    study-feng

      Hello,

      Here are my steps to access DB procedure by ORDS, but it can not work.

      Please teach how to solve the problem and the detail steps to access DB procedure with standalone ORDS(no APEX installed)

       

      1.download ords 18.4

      Oracle REST Data Services 18.4
      https://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html

      2.
      create procedure test by system user.

      SQL> conn system
      SQL> create or replace procedure test is
        2  begin
        3  htp.print ('<h1>Hello World</h1>');
        4  end;
        5  /

      3.
      update the <ords unzip directory>\params\ords_params.properties file as below:

      db.username=SYSTEM
      rest.services.ords.add=false

      4.

      refer to 2049531.1 to config ORDS.
      java -jar ords.war

      How to Install Oracle REST Data Services (ORDS) Without Installing the ORDS Schemas (ORDS_PUBLIC_USER and ORDS_METADATA) (Doc ID 2049531.1)

      5.

      start ORDS in standalone mode, try to access DB procedure by:
      http://localhost:8080/ords/system.test

       

      404  Not Found  displayed.

       

      Please teach how to config ORDS to access DB procedure.

       

      Thank  you.