Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

JDBC call procedure parameters issue


Manoj Chaurasia

Recommended Posts

Hi,

 

I have a BW process which should invoke a JDBC stored procedure. This procedure is having 3 input parameters and i am successfully able to run it in DB where as when i am calling this JDBC procedure in BW, it is not displaying the input parameters. I have refreshed the activity many times, reopened the project but still it is not showing the input parameters in it.

 

Any ideas how to resolve this issue.

 

Thanks

ashwini

Link to comment
Share on other sites

  • 3 years later...
I have definitely seen this issue with incompatible datatypes as Raja mentions. I am assuming you have already tested the connection and BW is able to connect to the Oracle instance successfully. Did you test the stored proc from the DB using the same user as BW is using. The BW user may not be able to see the proc.
Link to comment
Share on other sites

Hi Ashwini,

 

More often than not, this is an issue with the database driver that you are using. Try changing the database driver. If nothing works, you can use the SQL Direct Activity for writing the whole commmand like

"EXECUTE SP_TEST(PARAM1,PARAM2,PARAM3);"

 

Please make sure that you are adding the commas and semicolons while you are concatenating the command.

 

Let me know if that helps.

 

Best Regards,

Suvratanu

---------------------------------------------------------------------------------------------

Suvratanu Baidya | mailto:sbaidya@infocepts.com| www.infocepts.com

---------------------------------------------------------------------------------------------

Link to comment
Share on other sites

  • 4 years later...
×
×
  • Create New...