I have a customer would like to know whether he can write a store procedure that will return TEXT datatype from a value stored in lvarchar column? If yes, how?
I have previously suggested to create cast but I found from manual that there are restrictions on user-defined casts.
Restrictions on user-defined casts
You cannot create a user-defined cast between two built-in data types. You also cannot create a user-defined cast that includes any of the following data types:
Collection data types: LIST, MULTISET, or SET
Unnamed row types
Smart-large-object data types: CLOB or BLOB
Simple-large-object data types: TEXT or BYTE
Pinned topic SPL to retrun TEXT datatype from a value stored in lvarchar column?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-07-02T07:33:55Z at 2012-07-02T07:33:55Z by chinth
andreasl 100000CHVU375 Posts
Re: SPL to retrun TEXT datatype from a value stored in lvarchar column?2012-06-25T08:31:10ZThis is the accepted answer. This is the accepted answer.TEXT is on the negative list for UDR return data types.
So what you were trying to achieve wouldn't be possible as such.
You might be more lucky with OUT or INOUT parameters using the REFERENCES clause.