3 Replies Latest reply on Jan 19, 2016 5:36 PM by thatJeffSmith-Oracle

    ORA-06550 Assigning value to parameter

    3031421

      Hi trying to assign the date quarter to a variable, and am receiving this error message, how can I assign a value to this parameter on PL/SQL:

       

      declare

      Quarter varchar(2);

       

      begin

        select to_char(sysdate, 'YYYY-Q') into Quarter from dual;

          dbms_output.put_line(Quarter);

      end;

       

      [Error] Execution (5: 42): ORA-06550: line 2, column 42:

      PLS-00201: identifier 'vQUARTER' must be declared

      ORA-06550: line 2, column 50:

      PL/SQL: ORA-00904: : invalid identifier

      ORA-06550: line 2, column 3:

      PL/SQL: SQL Statement ignored

      ORA-06550: line 3, column 26:

      PLS-00201: identifier 'vQUARTER' must be declared

      ORA-06550: line 3, column 5:

      PL/SQL: Statement ignored