SqlDbx Forum

garbuya

Member

BUG - SqlDbx does not recognize Oracle packages

SELECT LEVEL, FLOOR(DBMS_RANDOM.VALUE( 20000, 40000)) VAL FROM DUAL CONNECT BY LEVEL <= 1000;
Getting error
ORA-00904: "DBMS_RANDOM"."VALUE": invalid identifier

PL/SQL processes it normally