Hi all,
I've seen a few questions asked around invoking stored procedures from within
Data Import Handler but none of them seem to indicate what type of output
parameters were being used.
I have a stored procedure created in Oracle database that takes a couple input
parameters and has an output parameter that is a reference cursor. The cursor
is expected to be used as a way of iterating through the returned table rows.
I'm using the following format to invoke my stored procedure in the Data Import
Handler's data config XML:
<entity name="entity_name" ... query="{call my_stored_proc(inParam1,
inParam2)}"> ...</entity>
I have tested that this query works prior to attempting to use it from within
the DIH. But when I attempt to invoke this stored procedure, it naturally
complains that the output parameter is not specified (essentially a mismatch in
the number of parameters).
I don't know of anyway to pass in a cursor parameter (or any output parameter
for that matter) to the stored procedure invocation from within the <entity>
definition. I would greatly appreciate if anyone could provide any pointers or
hints on how to proceed.
Thanks so much for your time
