Let's suppose that we have a spring web application, which is already deployed in Tomcat and we want to migrate to Weblogic Server.We must take care of the following:First create…
In Oracle ADF the weblogic.xml is automatically created.In order to change the context-root element, without editing the weblogic.xml after its creation, simply select:Project Properties > Java EE ApplicationThere you can…
Let's suppose that you want to return on Sys_RefCursor, some values, which does not exist in the database, thus should be created on the fly.One way to do this, is…
Here is how to query the dependencies of an object in Oracle DB:(in this example, which tables a package specification is depended on)select /*+ NO_PARALLEL */ * from (SELECT DISTINCTb.object_name…
Here is an anonymous block for the demonstration of Web-Service call capability using Oracle PL/SQL.The Web-Service takes 1 parameter (cust) as input and outputs a list with 4 columns.We provide…
It is very convenient for testing purposes (and not only) to keep a simple database in Excel format.In order to do this, every sheet in our excel file must represent…
Handling PL/SQL Exceptions:http://docs.oracle.com/cd/B10500_01/appdev.920/a96624/07_errs.htm
Please, view the following related article:Java: XPath: Read value from XML files
Please, view the following related article:Java: XPath: Read series of attributes from xml files
Please, view the following related article:Oracle DB: XPath: Extract part of xml