GitHunt
CL

clagomess/modplsql

Lightweight based Java server to run Oracle OWA (Oracle Web Agent)

mod-plsql

Lightweight based Java server to run Oracle OWA (Oracle Web Agent)

Download

Example

OWA Oracle procedure:

CREATE OR REPLACE PROCEDURE HELLO_WORLD (
    NUM_ENTRIES NUMBER,
    NAME_ARRAY OWA.VC_ARR,
    VALUE_ARRAY OWA.VC_ARR,
    RESERVED OWA.VC_ARR
) IS
BEGIN
    HTP.PRINT('Hello World');
    DBMS_OUTPUT.PUT_LINE('Test DBMS_OUTPUT');
END;

config.json:

{
  "dbUrl": "jdbc:oracle:thin:@localhost:1521:ORCLCDB",
  "dbUser": "DBBACKUP",
  "dbPass": "010203",
  "indexPage": "DBBACKUP.HELLO_WORLD",
  "params": [
    {"key": "foo", "value": "bar"}
  ]
}
  • Run: java -jar mod-plsql.jar
  • See: http://localhost:8000

Languages

Java90.9%PLSQL8.9%Dockerfile0.3%

Contributors

MIT License
Created July 22, 2019
Updated September 4, 2024