If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

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.