Message-Id: <10623.117237@fatcity.com> From: "Uldis Pavuls" Date: Mon, 18 Sep 2000 14:50:48 +0300 Subject: RE: PL/SQL Procedure not returning correct value not sure but might be you should use local pl/sql variable instead of bind variable in select statement. HTH, Uldis Uldis Pavuls DBA, Tieto Konts Financial Systems Ltd. Kr.Barona 32, Riga, Latvia, LV 1011 phone +371 7 286 660, fax +371 7 243 000 mailto:U.Pavuls@konts.lv, http://www.konts.lv > -----Original Message----- > From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of > raman.yagna@db.com > Sent: pirmdiena, 2000. gada 18. septembris 15:06 > To: Multiple recipients of list ORACLE-L > Subject: Re: PL/SQL Procedure not returning correct value > > > check your declaration of grnno ..... > > > ---------------------------------------- Message History > ---------------------------------------- > > > > Please respond to ORACLE-L@fatcity.com > > To: ORACLE-L@fatcity.com > cc: > > > > I am facing the problem in getting minimum value of a key item > conditionally > in PL/SQL Stored Procedure. The same thing is exactly working at > SQL prompt. > > My query is like this: > > Select min(grn_no) into :grnno from where > > we are using Oracle7.3.4 on Sco-Unix Relase5. > > Kindly suggest the solution as I am hanged-up. > > Regards and thanks in advance > Ajay Kothari > > Keep smile !!! Visit us at www.lipidata.com > > __________________________________________________ > Lipi Data Systems Ltd, Mumbai > > > -- > Author: Ajay Kothari > INET: akothari@lipidata.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > -- > Author: > INET: raman.yagna@db.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may