From: member22660@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)