Re: passing SYS_REFCURSOR as out parameter for Oracle stored procedure

2013-12-09 Thread Michael Della Bitta
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 c

passing SYS_REFCURSOR as out parameter for Oracle stored procedure

2013-12-06 Thread aniljayanti
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 na