You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
set SERVEROUTPUT ON;
DECLARE
TYPE population IS TABLE OF NUMBER INDEX BY VARCHAR2(64);
city_population population;
i VARCHAR2(64);
BEGIN
city_population('Smallville') := 2000;
city_population('Midland') := 750000;
city_population('Megalopolis') := 1000000;
city_population('Smallville') := 2001;
i := city_population.FIRST;
WHILE i IS NOT NULL LOOP
DBMS_Output.PUT_LINE
('Population of ' || i || ' is ' || city_population(i));
i := city_population.NEXT(i);
END LOOP;
END;
testcase code: stacktrace info: error info: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'_tab AS TABLE OF VARCHAR2(30) INDEX', expect IS, actual AS, pos 32, line 2, column 22, token AS
The text was updated successfully, but these errors were encountered:
ZhengguanLi
changed the title
Support Oracle: "DECLARE TYPE" in PL/SQL declaration
Support Oracle Associate Array(Index-By table) in: "DECLARE TYPE" in PL/SQL declaration
May 17, 2024
ZhengguanLi
changed the title
Support Oracle Associate Array(Index-By table) in: "DECLARE TYPE" in PL/SQL declaration
Support Oracle Associate Array(Index-By table) in PL/SQL declaration
May 17, 2024
Now we only support in the
CREATE TYPE
sql for Oracle index-by table syntaxdbtype: Oracle
dbversion: 19
druid verion: 1.2.23-SNAPSHOT
error sql:
testcase code:
stacktrace info:
error info: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'_tab AS TABLE OF VARCHAR2(30) INDEX', expect IS, actual AS, pos 32, line 2, column 22, token AS
The text was updated successfully, but these errors were encountered: