Thursday, April 8, 2021

Call Web Service from Stored Procedure on Oracle 11g



@?/rdbms/admin/dbmsnacl.sql
org.springframework.batch.repeat.support.RepeatTemplate - Repeat is complete according to policy and result value. org.springframework.batch.repeat.support.RepeatTemplate - Repeat operation about to start at count=?

Wednesday, August 9, 2017

How to work with JSON on Oracle Database 11g?

Oracle Database 11g

There are "json, json_value, and json_list" types for Oracle 11g:

Put in json:


Get json:


Important links:

  • https://www.morganslibrary.org/reference/pkgs/utl_tcp.html
  • http://alex-td.blogspot.mx/2013/02/invoking-restful-web-service-in-oracle.html
  • http://orclapex.blogspot.mx/2014/04/calling-apis-from-plsql-using-utlhttp.html
  • https://oracle-base.com/articles/misc/apex_web_service-consuming-soap-and-rest-web-services
  • https://community.oracle.com/thread/1037981
  • https://stackoverflow.com/questions/25807835/old-sql-history-in-oracle-sql-developer



Best regards,