aspose file tools*
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 Soft Skills this week in the Jobs Discussion 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Issue in passing Oracle User Defined Types to PL SQL from Websphere Application Server