Tim

VARCHAR's are limited to 512 characters so I guess if I need a larger parameter than that I'd need to use a CLOB and from my quick experiment it seems that all I need to do is alter the parameter type. Is it really that simple?

Roy Lambert

Roy,

<< VARCHAR's are limited to 512 characters so I guess if I need a larger
parameter than that I'd need to use a CLOB and from my quick experiment it
seems that all I need to do is alter the parameter type. Is it really that
simple? >>

Actually it's simpler than that - VARCHARs really don't have a limit for
parameters and variables in SQL/PSM.  The limit only applies to columns.
Also, in case you didn't know, you can just declare a VARCHAR parameter or
variable as simply VARCHAR with no length specifier, and it will behave just
like a String declaration in Delphi.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

<<and it will behave just
>like a String declaration in Delphi.>>

THAT BIT I didn't know - thanks.

Roy Lambert