Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    Unanswered: var_numeric return type

    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;

  2. #2
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    Does anyone have a clue already?

    Does anyone have a clue already?

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up Re: var_numeric return type

    Hi,

    Why can't U convert the return numeric datatype into varchar, before using it in the code.
    SATHISH .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •