Oracle stored functions
From: John Parrott <spo_at_interlog.com>
Date: 1996/08/16
Message-ID: <4v107p$bk9_at_news.interlog.com>#1/1
Date: 1996/08/16
Message-ID: <4v107p$bk9_at_news.interlog.com>#1/1
When executing a stored Oracle function in Delphi using a TQuery object which
is supposed to return a varchar2 value (e.g. 'select funcName(param1) as
FuncVal from dual'), Delphi always wants to cast the value as a memo instead
of a string.
Oracle does not provide a way (that I know of) to cast strings as strings.
To_char() does not work because it wants a date or string.
John Parrott
Elysium Financial Systems
http://www.interlog.com/~spo
Received on Fri Aug 16 1996 - 00:00:00 CEST