Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Issue in passing Oracle User Defined Types to PL SQL from Websphere Application Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

Issue in passing Oracle User Defined Types to PL SQL from Websphere Application Server

DeepakN kumar
Greenhorn

Joined: Apr 14, 2012
Posts: 27
HI,

I am facing an issue when trying to pass Oracle collection object(User Defined Types) from Java to PL SQL. The issue happens inside J2EE application which is running inside Websphere Application Server 6.x. My database is Oracle 10g and i am using ojdbc1.4.jar as thin driver.
The issue is that when i pass the Oracle Object from java side, the attribute values at the Oracle PL SQL side is coming as empty. I have tried the same java code in a standalone application and it works fine. The issue happens only when the application is running inside WAS.
Anybody has any idea how to pass Oracle User Defined Types from WAS server to PL SQL?
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Hi DeepakN,

I am not familiar with WAS but it sounds like a driver issue. At least can you verify that your application running on WAS also uses the same version of Oracle JDBC driver as your local/standalone application does?

Regards,
Fatih.
DeepakN kumar
Greenhorn

Joined: Apr 14, 2012
Posts: 27
yes it is using the same driver(ojdbc1.4)
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

Depak, why have you created a new thread for this?
it is exactly the same question as your previous thread. i am closing this thread.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Issue in passing Oracle User Defined Types to PL SQL from Websphere Application Server
 
Similar Threads
How to pass class object in call to pl/sql procedure ?
Passing in array parameter to an Oracle stored procedure
Passing array of Oracle colection objects from java to PL SQL
calling pl/sql in Java
Passing java arrays to PL/SQL and vice versa