lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From binoybt <bino...@gmail.com>
Subject Stored procedure not working. How to pass resultset?
Date Thu, 05 May 2011 11:54:55 GMT
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.

Mime
View raw message