• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Issue calling a stored procedure from Weblogic 8.1 workshop project

 
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi

I have one stored procedure, which takes one input parameter and second is output parameter. When I call the stored procedure using DAO design pattern inside weblogic 8.1 workshop proejct, it is failing and giving me below exception,

"Incorrect parameter bindings for stored procedure call.Check your bindings against the stored procedure parameters."

Surprisingly, when I call the same stored procedure using a stand alone java class(inside which I am creating a database connection, callable statement, setting the in parameter and the registering the output parameter and executing the callable statement) it is working fine and giving me the output.

Thanks & Regards
Ashwin
 
Bartender
Posts: 6663
5
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please mention

Database name
Database version
Driver version
Driver name
Driver type
XA Vs Non XA connection
If Non XA what TX does it use
What is the TX setting of the stored procedure. Chained Vs unchained.
 
Ash Kondhalkar
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Deepak,

It worked. Thank you for asking me below questions. I found that in standalone java class I was using Oracle's database driver while in the weblogic 8.1 datasource I was using BEA weblogic's database driver class. After I changed by datasource driver class to Oracle driver classs it worked.

Thanks a lot once again.
Regards
Ashwin
 
Deepak Bala
Bartender
Posts: 6663
5
MyEclipse IDE Firefox Browser Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you for sharing the solution. There are known problems with some driver types for Oracle / Sybase.
 
Come have lunch with me Arthur. Adventure will follow. This tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic