Home -> Usenet -> comp.databases.oracle -> variable datatype returning

variable datatype returning

From: thepercival <member22660_at_dbforums.com>
Date: Fri, 07 Nov 2003 06:33:11 -0500
Message-ID: <3571546.1068204791_at_dbforums.com> 







Hello,





I have a stored procedure and the return data type is number(16) as you
can see. but I get it back in the code as a var_numeric and then the
precision depends on the value of the returndata. So 0 fits into a short
so I have to convert to a short, although I say that my stored procedure
has to return a NUMBER(16), thus int. Can anyone tell me how I can
determine my return datatype beforehand?





many thanks





CREATE OR REPLACE PROCEDURE ish.applsp_IsForeignKeyProtected



(



cDbd IN VARCHAR2,



cTable IN VARCHAR2,



cFKey IN VARCHAR2,



rc1 IN OUT refcurpkg.rct1



) AS



IsProtected NUMBER(16);



BEGIN


IsProtected := 1;





OPEN rc1 FOR



SELECT IsProtected FROM DUAL;



END;




--
Posted via http://dbforums.com


Received on Fri Nov 07 2003 - 12:33:11 CET












Original text of this message