Claus Pedersen
Member³
I have the following code with two private types:
Code completion recognises the two types when performing code completion in the procedure header (line 1). If I place the cursor just before the closing paranthesis in line one and press the code completion key, the types myType1 and myType2 are displayed. This is an error. Private types can of course never be used in a procedure declaration.
Code:
CREATE OR REPLACE PROCEDURE tester (var IN myType) IS
SUBTYPE myType1 IS VARCHAR2(1);
TYPE myType2 IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
BEGIN
NULL;
END tester;