Posts Tagged ‘jdbc’

The below error can happen when you run any kind of a process that uses JDBC:

ORA-28267: Invalid Namespace Value In SOA Suite

This is a bug!
The cause of the problem is when using Oracle JDBC Driver file (ojdbc6dms.jar) and calling a DB object (procedure, function etc…) that issues SQL over a DB link from 11g to 10g DB.

There is no patch for that at the moment.
I found a workaround, that was approved by oracle:

Under the below folders, replace the ojdbc6dms.jar file with ojdbc6.jar file:

You can find the ojdbc6.jar driver in the below link:

It is also suppose to be under $MID_HOME/wlserver_10.3/server/lib. You can just copy it from there.

There is one exception: No JDBC metrics will be produced. If you need it, you will have to open SR.

Good Luck!

Read Full Post »