Forum Discussion

alibaba82's avatar
alibaba82
Super Contributor
18 years ago

How to call stored procedures in a datasource step.

Hello, can you shed some light on how to call a stored procedure using the datasource step. I specified the driver, connection string. Not sure how to use the properties and SQL query. thanks A...
ANDYtyara's avatar
ANDYtyara
Occasional Contributor
9 years ago

Hi Team,

I am having one oracle store procedure craeted with IN and OUT parameters in ORACLE database.

I am trying to call it from SOAP 5.2.1 version with JDBS request test step.


Can you please tell me how to call store procedure with input and output parameters?

Also do i need to mention all input and output parameters in property list first ? and also how to pass them while calling store procedure?

It would be helpful if you explain with one example.


Your help would be appreciated.

groovyguy's avatar
groovyguy
Community Hero
9 years ago

ANDYtyara: You've replied to a post that is almost 9 years old. You will want to create a post for your problem instead of attaching it to a long since dormant thread. This will give the people coming into the thread more visibility for your problem instead of potentially confusing the original problem with your's.