SQL Developer 3 and simple_integer
892685Oct 5 2011 — edited Oct 6 2011Hi can anyone help me with something, I have checked everywhere else and can't find an answer.
Does SQL Developer v 3 support the new 11g data type simple_integer? I have a simple procedure shown below
set serveroutput on;
DECLARE
n simple_integer := 1;
BEGIN
FOR j IN 1..4 LOOP
n := n + 1;
DBMS_OUTPUT.PUT_LINE(TO_CHAR(n, 'S9999999999'));
END LOOP;
FOR j IN 1..4 LOOP
n := n - 1;
DBMS_OUTPUT.PUT_LINE(TO_CHAR(n, 'S9999999999'));
END LOOP;
END;
When I try and run this I get the error
Error report:
ORA-06550: line 2, column 5:
PLS-00201: identifier 'SIMPLE_INTEGER' must be declared
ORA-06550: line 2, column 5:
PL/SQL: Item ignored
When I change simple_integer to integer or pls_integer it works. but the new type of simple_integer doesn't. Can anyone shed light on this because I'm at a loss as to the problem.
Edited by: user9313611 on Oct 5, 2011 6:12 PM
Edited by: user9313611 on Oct 5, 2011 6:21 PM