PLS-00103: Encountered the symbol "TO" when expecting one of the following:

Julia Kurakula 46 Reputation points
2023-02-02T10:32:22.9533333+00:00
LINE/COL ERROR:
369/42 PLS-00103: Encountered the symbol "TO" when expecting one of the following: ( - + case mod new null continue avg count current max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe <an alternatively-quoted SQ

I am getting this error in this part of code:

         if  year_float_minutes > (eligible_minutes * 3) then
                  record_error(end_date, header_id, 0, rule_set, 'ABCDE',
                        '[year]=' || to c.labor_date_year);
                  l_rpt := 1;
           end if;
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
42,028 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 46,041 Reputation points
    2023-02-02T10:40:06.31+00:00

    That's Oracle PL/SQL and an error raised by Oracle; so has nothing to do with Microsoft SQL Server.

    Better post at https://forums.oracle.com/ords/apexds/domain/dev-community

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.