My Blog

All about my activities, Ideas and everything.

Category: Oracle

Oracle with GUID

Have you ever wanted to know that how Oracle generate GUID? This is the answer. I found this website shows how to use Oracle to generate GUID for us. http://feuerthoughts.blogspot.com/2006/02/watch-out-for-sequential-oracle-guids.html This is the code SQL Package CREATE OR REPLACE PACKAGE guid_pkg IS SUBTYPE guid_t IS RAW (16); SUBTYPE formatted_guid_t IS VARCHAR2 (38); – Example: {34DC3EA7-21E4-4C8A-BAA1-7C2F21911524} [...]

HowTo : Disable/Enable Oracle ESB status at runtime: Scheduling polling frequency

I’m being assigned a task which is Scheduling polling frequency in File adapter. Typically, File Adapter will collect the files from specified folder at the polling frequency time parameter, such as every 1 second or 1 min. What about specified time, every 6pm or every morning? How?? This is my solution. Quartz. But one thing [...]

OC4J : set http.webdir.enable option to be enabled in 10.1.3.x

in Oracle Application Server 10.1.2.x this option is enabled, but in 10.1.3.x this option is disabled. So, the way to enable this option is to put the java option to OC4J. This is for OC4J standalone COMMAND java -Dhttp.webdir.enable=true -jar oc4j.jar But if you are using embedded-oc4j, look at this topic