Stored procedure not working. How to pass resultset?

[binoybt]

Hi

I am new to Solr. I wrote a stored procedure in Oracle.

I tried calling from solr. But the procedure is not getting executed as it
expects a resultset as out param.

CREATE OR REPLACE PROCEDURE GETSEARCHQUERY(p_cursor in out sys_refcursor) AS 
BEGIN
OPEN p_cursor FOR

select *   from X where X.id = 10730;
                               
END GETSEARCHQUERY;

Dataconfig.xml

  <entity name="coreY" transformer="TemplateTransformer" pk="id" 
                 
                 query="{call GETSEARCHQUERY()}"
                 deltaQuery="{call GETSEARCHQUERY()}">
                        
        </entity>

Can someone help me.

Thanks
Binoy

--
View this message in context: 
http://lucene.472066.n3.nabble.com/Stored-procedure-not-working-How-to-pass-resultset-tp2903090p2903090.html
Sent from the Lucene - General mailing list archive at Nabble.com.