"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message news:<szw89.16122$WJ3.2636177_at_news1.news.adelphia.net>...
> My guess
>
> This is what you are doing from the command line
>
> execute p_sum(2,'02-Jun-2002')
>
> and this is what you are asking for from the procedure
>
> execute p_sum(2,02-Jun-2002)
>
> Try putting 2 more single quotes, before and after the date field, like this
>
>
> exe_ps := 'begin ' || procedure_name || '(' || time_type || ',''' ||
> report_date || '''); end;';
>
>
> and it will produce
>
> execute p_sum(2,'02-Jun-2002')
>
Scott - Thanks for the help. That's exactly what the problem was!
Marcie
Received on Wed Aug 21 2002 - 07:53:40 CDT
