CHAR function in Oracle view is converted to Memo, not String

[dtempleton]

I started by building a function in Oracle8i that takes two inputs of type CHAR and returns a value of type CHAR. I then used this function as a column in a view. When I place that view in a Crystal 8.5 Report, the field is displayed as type Memo.

Any ideas as to how I can get it in the form of String instead of Memo?

 

[lyanch]

The length has to be less than 255 (maybe up to equal.. I can't remember the ones that are on the edge). So, if the view field is char(300), even if you only use 55 of those 300 Crystal will consider it to be a memo.

Lisa

 

[dtempleton]

Thanks Lisa! You definitely put me on the right path.

I took the function in the view, and placed it inside of a SUBSTR function to reduce its length. Now it shows up as String!