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/appinions<https://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. >
