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_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> raman.yagna_at_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_at_fatcity.com
>
> To: ORACLE-L_at_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 <table_name> where<condition>
>
> 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_at_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_at_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_at_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_at_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
Received on Mon Sep 18 2000 - 06:50:48 CDT