Avatar of Scarlett72
Scarlett72

asked on 

ORA-06550 Assigning value to parameter

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
DatabasesOracle DatabaseSQL

Avatar of undefined
Last Comment
Scarlett72

8/22/2022 - Mon