Re: Stored Procs and char parameters

On Mon, 9 Feb 2004 17:19:04 +0100, "lfb" <lfinet_baron_at_hotmail.com> wrote:

>Hello,
>
>I'd like to send as an input parameter a char(10) value to a stored proc.
>Is it possible ? When I write myparameter IN CHAR(10), it doesn't compile.
>
>Thanks,
>Laurent.
>

You can't have varchar2(n) and char(n) as formal parameter to a procedure or function, only varchar2 and char. As your actual parameter is of the correct length it doesn't matter.

--
Sybrand Bakker, Senior Oracle DBA