martedì 7 febbraio 2017

OWM - Set oracle workspace from java application

For the connect to an Oracle database 12c which uses Oracle Workspace Manager from a java application.
It is  possible trying to execute the following command from my java application.

From pl-sql

EXECUTE DBMS_WM.GotoWorkspace('WORKSPACE_NAME');

in the java code

String setWorkspace = "CALL DBMS_WM.GotoWorkspace('WORKSPACE_NAME')";
CallableStatement cs = conn.prepareCall(setWorkspace);
cs.execute();