Re: Oracle stored functions
From: Alan Gauld <Alan_Gauld_at_gssec.bt.co.uk>
Date: 1996/08/20
Message-ID: <321A0409.547_at_gssec.bt.co.uk>#1/1
Date: 1996/08/20
Message-ID: <321A0409.547_at_gssec.bt.co.uk>#1/1
John Parrott wrote:
>
> 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.
I'm not sure if this is relevant but Oracle 7 supports Varchars of up to 2K long.
Maybe something in the BDE prevents strings being longer than 255 thus memo is the more appropriate type.
This is a pure guess tho'!
Alan g. Received on Tue Aug 20 1996 - 00:00:00 CEST