Mike Neo

Greenhorn
+ Follow
since Nov 07, 2019
Mike likes ...
Oracle Java
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Mike Neo

Hi all,
I've a user defined type in oracle like this:



and I need to do a simple query:



from Java where ROLES attribute is defined as:



I need to extract the ROLES attribute from Java using WebLogic but I get this error:



The code I run from JDeveloper(v. 12.2.1.4.0) is below:



The strange thing is that when I use this code as stand alone application in Eclipse:



It runs correctly.

Any idea on how I can get it working on weblogic?

Another hint: when I run the code on JDeveloper 12.1.2.0.0 it runs fine.