I have a table/file containing a list of policy_nos and I have a stored procedure, which takes this policy_no as a parameter to generate some output.
so, my question is, how can I implement it in DS?
I Need to call the procedure for ecah policy_no in the list.
Hi! Ray,
I think,
the problem is not executing the stored procedure. but, how should I pass more than one policy number into stored procedure...
I mean, calling stored procedure for every policy....!!!
Select the table that contain the policy_no thorugh a oracle stage and link it to the ODBC stage which calls the stroed procedure. The output of the OCI will the input for the ODBC.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'