lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Simon Willnauer <simon.willna...@googlemail.com>
Subject Re: Stored procedure not working. How to pass resultset?
Date Fri, 06 May 2011 06:50:44 GMT
I think you should rather send this mail to solr-user@lucene.apache.org

simon

On Thu, May 5, 2011 at 1:54 PM, binoybt <binoybt@gmail.com> wrote:
> 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