Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    27

    Unanswered: Long columns in view

    I have created a view that calls various stored functions for some of it's columns.
    These columns are all defined as varchar2(4000) in the view definition. Can I force this to be smaller?

    I tried to change:
    FUNCTION GetInterestReason(pModCd IN Varchar2(5))
    RETURN Varchar2;
    to
    FUNCTION GetInterestReason(pModCd IN Varchar2(5))
    RETURN Varchar2(10);
    in the procedure definition but this is no good.

    I don't think I can use an OUT parameter as I have nothing to assign it to in the CREATE VIEW script.

    Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Long columns in view

    Originally posted by tdrevans
    I have created a view that calls various stored functions for some of it's columns.
    These columns are all defined as varchar2(4000) in the view definition. Can I force this to be smaller?

    I tried to change:
    FUNCTION GetInterestReason(pModCd IN Varchar2(5))
    RETURN Varchar2;
    to
    FUNCTION GetInterestReason(pModCd IN Varchar2(5))
    RETURN Varchar2(10);
    in the procedure definition but this is no good.

    I don't think I can use an OUT parameter as I have nothing to assign it to in the CREATE VIEW script.

    Thanks!
    I wonder if you could use SUBSTR(GetInterestReason(parm),1,10) ...
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Sep 2003
    Posts
    27
    That works!

    I don't know that that will make it any quicker, but it helps me display it more easily. Thanks.

Posting Permissions

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