variable datatype returning
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