Return-Path: 
 <general-return-3214-apmail-lucene-general-archive=lucene.apache.org@lucene.apache.org>
X-Original-To: apmail-lucene-general-archive@www.apache.org
Delivered-To: apmail-lucene-general-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 44CE438F2
	for <apmail-lucene-general-archive@www.apache.org>;
 Fri,  6 May 2011 07:02:45 +0000 (UTC)
Received: (qmail 82524 invoked by uid 500); 6 May 2011 07:02:44 -0000
Delivered-To: apmail-lucene-general-archive@lucene.apache.org
Received: (qmail 81951 invoked by uid 500); 6 May 2011 07:02:43 -0000
Mailing-List: contact general-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:general-help@lucene.apache.org>
List-Unsubscribe: <mailto:general-unsubscribe@lucene.apache.org>
List-Post: <mailto:general@lucene.apache.org>
List-Id: <general.lucene.apache.org>
Reply-To: general@lucene.apache.org
Delivered-To: mailing list general@lucene.apache.org
Received: (qmail 81728 invoked by uid 99); 6 May 2011 07:02:41 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 May 2011 07:02:41 +0000
X-ASF-Spam-Status: No, hits=3.4 required=5.0
	tests=FREEMAIL_FROM,FREEMAIL_REPLYTO,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of
 simon.willnauer@googlemail.com designates 74.125.82.176 as permitted sender)
Received: from [74.125.82.176] (HELO mail-wy0-f176.google.com) (74.125.82.176)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 May 2011 07:02:36 +0000
Received: by wyb40 with SMTP id 40so3375454wyb.35
        for <general@lucene.apache.org>; Fri, 06 May 2011 00:02:15 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=googlemail.com; s=gamma;
        h=domainkey-signature:mime-version:reply-to:in-reply-to:references
         :date:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        bh=ET+Cc14rPt2rm/WJgmEyz6HiA9LEf5aYuF1Ewk3fPaY=;
        b=ev1JcOl/HE9glgk33nLzTuaotBl5aTDyftPxGHQ5QhRdnZ4Bib0n3+W3wrCjRrGqmM
         GSFisjCEUUTlbxziCIvc2vSpPfm2bDjqqtieRVmu/eGHCFunNZTM07AB3TVCsZw23JV0
         agVv8lkDHjLunRLK67ta/OoHFEyUqObvdsUAw=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:reply-to:in-reply-to:references:date:message-id
         :subject:from:to:content-type:content-transfer-encoding;
        b=Ym2CN7rH2Ag6MpNEeKLRqg+WDMkP23pFmcOaKfgeQCN1nRCj+ZQRU1mohuNEqnsVyP
         FrEEKGPJ0dWlDKLuq7Wb8DckKYQwFa/Hpa5eGfQbVKJTBknNc38PGPmIhYVGyZMvw2jy
         FWwbhHsZ7s/5mQpi+jgFLaubZhigdU/dF2mT0=
MIME-Version: 1.0
Received: by 10.216.61.206 with SMTP id w56mr2451409wec.97.1304664644266; Thu,
 05 May 2011 23:50:44 -0700 (PDT)
Received: by 10.216.180.139 with HTTP; Thu, 5 May 2011 23:50:44 -0700 (PDT)
Reply-To: simon.willnauer@gmail.com
In-Reply-To: <1304596495812-2903090.post@n3.nabble.com>
References: <1304596495812-2903090.post@n3.nabble.com>
Date: Fri, 6 May 2011 08:50:44 +0200
Message-ID: <BANLkTik8_VFbUrkin_EPjkXa+jPkuaoCOw@mail.gmail.com>
Subject: Re: Stored procedure not working. How to pass resultset?
From: Simon Willnauer <simon.willnauer@googlemail.com>
To: general@lucene.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 i=
t
> expects a resultset as out param.
>
> CREATE OR REPLACE PROCEDURE GETSEARCHQUERY(p_cursor in out sys_refcursor)=
 AS
> BEGIN
> OPEN p_cursor FOR
>
> select * =C2=A0 from X where X.id =3D 10730;
>
> END GETSEARCHQUERY;
>
> Dataconfig.xml
>
> =C2=A0<entity name=3D"coreY" transformer=3D"TemplateTransformer" pk=3D"id=
"
>
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 query=3D"{call GE=
TSEARCHQUERY()}"
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 deltaQuery=3D"{ca=
ll GETSEARCHQUERY()}">
>
> =C2=A0 =C2=A0 =C2=A0 =C2=A0</entity>
>
> Can someone help me.
>
> Thanks
> Binoy
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/Stored-p=
rocedure-not-working-How-to-pass-resultset-tp2903090p2903090.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
>