• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling Stored procedures

 
Raja Raja
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to call a oracle 9i stored procedure from a stateless session bean. I want to send a array to stored procedure. i use the class ArrayDescriptor found in classes12.zip to send the array. The array descriptor needs Connection object as one of the parameter. Since i am using Weblogic app server, when i get a connection from the Connection pool thru TX data Source , i get an weblogic.jdbc.jts.Connection object. Since this Connection object is incompatible with ArrayDescriptor, i get a class cast connection. On introspecting the ArrayDescriptor i found the Connection object is internally casted to OracleConnection class and Oracle Connection extends java.sql.Connection. pl. note ArrayDescriptor and Oracle Connection are both found in claases12.zip supplied by Oracle.
Can anybody suggest a asolution to overcome this problem.
 
Raja Raja
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Issue most urgent. Can anybody address it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic