Bookmark Topic Watch Topic
  • New Topic

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

 
DeepakN kumar
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 182
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 27
  • Mark post as helpful
  • send pies
  • Report post to moderator
yes it is using the same driver(ojdbc1.4)
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
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.
 
    Bookmark Topic Watch Topic
  • New Topic