orskog
>To: solr-user@lucene.apache.org
>Sent: Sunday, June 3, 2012 12:28 AM
>Subject: Re: Using Data Import Handler to invoke a stored procedure with
>output (cursor) parameter
>
>Right, or create a view.
>
>On Fri, Jun 1, 2012 at 8:11 PM, Michael Della Bitta
> wrote:
rce class of the DIH, I
>> think I'm at a dead end.
>>
>> If anyone knows of any alternatives I would greatly appreciate hearing
>> them.
>>
>> Thanks for the responses as usual.
>>
>> Cheers.
>>
>>
>>
>>
>> >___
the Data Import Handler to get a handle on the output
> parameter from the stored procedure. It's a bit surprising though that no
> one has ran into this scenario but I suppose most people just work around
> it.
> >>
> >> Anyone else care to shed some more light on al
ppose most people just work around it.
>>
>> Anyone else care to shed some more light on alternative approaches? Thanks
>> again.
>>
>>
>>
>>>________________
>>> From: Michael Della Bitta
>>>To: solr-user@lucene.apache.org
>>>Sent: Thursday, May 31, 2012 9:40 A
___
>> From: Michael Della Bitta
>>To: solr-user@lucene.apache.org
>>Sent: Thursday, May 31, 2012 9:40 AM
>>Subject: Re: Using Data Import Handler to invoke a stored procedure with
>>output (cursor) parameter
>>
>>I could be wrong about this, bu
lucene.apache.org
>Sent: Thursday, May 31, 2012 9:40 AM
>Subject: Re: Using Data Import Handler to invoke a stored procedure with
>output (cursor) parameter
>
>I could be wrong about this, but Oracle has a table() function that I
>believe turns the output of a function as
I could be wrong about this, but Oracle has a table() function that I
believe turns the output of a function as a table. So possibly you
could wrap your procedure in a function that returns the cursor, or
convert the procedure to a function.
Michael Della Bitta
---
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 outpu
