I would probably do something like create a function that called your
stored procedure and returned the function, and then call TABLE() on the
result of your function so that DataImportHandler gets something that looks
like a table to it. I'm not sure that DataImportHandler is set up to deal
with cursors or out parameters.
Michael Della Bitta
Applications Developer
o: +1 646 532 3062 | c: +1 917 477 7906
appinions inc.
“The Science of Influence Marketing”
18 East 41st Street
New York, NY 10017
t: @appinions https://twitter.com/Appinions | g+:
plus.google.com/appinionshttps://plus.google.com/u/0/b/112002776285509593336/112002776285509593336/posts
w: appinions.com http://www.appinions.com/
On Fri, Dec 6, 2013 at 5:18 AM, aniljayanti aniljaya...@yahoo.co.in wrote:
Hi,
I am using solr 3.3 for index generation with sql server, generating index
successfully, now I am trying to generate with Oracle DB. I am using
*UDP_Getdetails* procedure to generate the required indexes. In this
procedure its taking 2 inputs and 1 output parameters.
*input params :
id
name
output params :
cv_1 IN OUT SYS_REFCURSOR*
In solr, data-config.xml below is my configuration.
*entity name=index query=UDP_Getdetails(32,'GT', ); *
I donot know how to pass *SYS_REFCURSOR* to procedure in solr.
Please help me out of this.
Thanks in Advance,
Aniljayanti
--
View this message in context:
http://lucene.472066.n3.nabble.com/passing-SYS-REFCURSOR-as-out-parameter-for-Oracle-stored-procedure-tp4105307.html
Sent from the Solr - User mailing list archive at Nabble.com.