- 1. How to handle Oracle BLOB columns via Database Link ...
- (Oracle)
- Oracle Developers are often faced with the problem to handle LOB data between several oracle instances via a database link. With plain SQL it is not allowed to select, insert or update a LOB on ...
- Created on 05 October 2016
- 2. How to set manual locks to synchronize processes in Oracle
- (PL/SQL)
- ... offers the dbms_lock package which is very helpful there to solve problems arround locking and synchronizing. The best way to handle it is, to each have a function for set and release ...
- Created on 18 November 2015
- 3. How to Java programming in Oracle Database
- (Java)
- ... , because of the complexity of the parameter. Second, we need another PL/SQL function, which handles the parameter passing from Java to PL/SQL. This is the function we provide as an external interface, ...
- Created on 07 December 2014
- 4. Oracle Goodies for XML and JSON
- (PL/SQL)
- ... .. and the code of the corresponding Package Function: function sql2xml(i_sql_string in varchar2) return xmltype is l_context_handle dbms_xmlgen.ctxhandle; l_xml xmltype; l_r ...
- Created on 27 September 2014





