Hello!
I declare a variable.
DECLARE cSuch CONSTANT VARCHAR2(30) := 'Aurich';
BEGIN
SELECT * FROM all_tab_columns WHERE data_type like '%VARCHAR2' and owner = 'WODIS';
END;
And although I did not use it, I get the following error message:
Fehler beim Start in Zeile : 6 in Befehl -
DECLARE cSuch CONSTANT VARCHAR2(30) := 'Aurich';
BEGIN
SELECT * FROM all_tab_columns WHERE data_type like '%VARCHAR2' and owner = 'WODIS';
END;
Fehlerbericht -
ORA-06550: Zeile 3, Spalte 3:
PLS-00428: In dieser SELECT-Anweisung wird eine INTO-Klausel erwartet
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
What could be wrong?