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;
Open in new window
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