Strange Sqls behavior in Ora 7.3.2 SP

From: Akawiec Ed <akawiec_at_theglobe.com>
Date: Thu, 2 Dec 1999 13:06:20 +0300
Message-ID: <825g7b$6v$1@aaanet.ru>

When I call Stored Procedure .
Declared like this
CREATE OR REPLACE
FUNCTION R5 (TTT NUMBER) RETURN VARCHAR2 IS   RRR NUMBER ;
BEGIN
  SELECT BBB INTO RRR FROM (
    SELECT MAX(N_V) AS BBB FROM Z_DOC ) ;   RETURN TO_CHAR(RRR) ;
END ;
It returns value passed to ttt as rrr. If i call this Sql from Sql Plus
it works FINE.

Is any clue about this strange BUG ?
May be upgrade to the 7.3.4 will help (Where I can find it)?

Thanks in advance
Ed Received on Thu Dec 02 1999 - 04:06:20 CST