Re: Dynamic SQL problem

> SQL> begin
> 2 test_run(''11-may-93'', 'O', 1990, 20);
> 3 end;
> 4 /
> begin
> *
 

> [2] [13] [PLS-00103: Encountered the symbol "11" when expecting one of
> the following:
> . ( ) , * _at_ % & | = - + < / > in mod not range rem => ..
> an exponent (**) <> or != or ~= >= <= <> and or like between
> is null is not ||
> The symbol "(" was substituted for "11" to continue.

It looks like you are trying to send a date string with embedded quotes to the procedure? If that is the case then you should invoke the procedure like so:

        test_run('''11-MAY-93''','0',1990,20);

good luck.
-Steve Edwards
-SCDNR Received on Thu Sep 18 1997 - 00:00:00 CEST