Function in view allways returns VARCHAR2(4000)

From: <jeanch_at_my-deja.com>
Date: 2000/06/23
Message-ID: <8ivhtp$qbs$1@nnrp1.deja.com>#1/1

Folks,

o I've got a view that call a function like below [CREATE OR REPLACE VIEW fish ( NAME, MID) AS SELECT getName(F.NAME, F.MID) NAME,F.MID MID FROM FISH_T F] o getName returns a VARCHAR2(50) however when I do a describe like on that view it shows that NAME is of type VARCHAR2(4000); basically oracle has overwritten my datatype to be the maximum varchar2

o I want the type to stay as I defined it because varchar2(4000) causes me problems when I try to write reports using MSAccess; Varchar2 is converted into a MEMO instead of text; and I know that I cannot join table that have memo in them.

o So if you could tell me how I could keep that type safe that'd be brilliant. Alternatively how could I make MSAcess understand my types

Cheers
JC

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 23 2000 - 00:00:00 CDT