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...
omatzura's avatar
omatzura
Super Contributor
18 years ago
Hi Ali,

The properties should be a list of properties that will be mapped to the values in each row returned by the stored procedure. The SQL should be in the following format:

{call procedure_name[(?, ?, ...)]}

so for example

{call sp_getorders( '${Properties#customerId}' )}

would call the sp_getorders stored procedure with the customerId property as its only argument..

Hope this helps!

regards,

/Ole
eviware.com