ORACLE-STORED-PROCEDURE

ol test connection

[module folder]> ol test connection --url jdbc:oracle:thin:@//myhost:1521/myservicename --username demo --password 1234 --driver-class-name oracle.jdbc.driver.OracleDriver

[module folder]$ ol test connection --url jdbc:oracle:thin:@//myhost:1521/myservicename --username demo --password 1234 --driver-class-name oracle.jdbc.driver.OracleDriver

Return to tutorial

ol add

[module folder]> ol add --schema DEMO --package BANK_EXAMPLE --storeProcedure GET_ACCOUNT_BY_ID --object-id 12345 --subprogram-id 12345

[module folder]$ ol add --schema DEMO --package BANK_EXAMPLE --storeProcedure GET_ACCOUNT_BY_ID --object-id 12345 --subprogram-id 12345

Return to tutorial