Ad order in anonymous pl / sql block

Question

I have an anonymous pl / sql block with a procedure declared inside it, as well as a cursor. If I declare a procedure before the cursor, it fails. Is there a requirement for cursors to be declared before procedures?

What other rules exist for the declaration order in the pl / sql block?

It works:

DECLARE
 cursor cur is select 1 from dual;
 procedure foo as begin null; end foo;
BEGIN
 null;
END;

Error with error PLS-00103: Encountered the symbol "CURSOR" when expecting one of the following: begin function package pragma procedure form

DECLARE
 procedure foo as begin null; end foo;
 cursor cur is select 1 from dual;
BEGIN
 null;
END;

Answer 1

Cursors, variables, constants, and types must be declared before packages / functions.

This one won't work either:

DECLARE
 procedure foo as begin null; end foo;
 x VARCHAR2(10);
BEGIN
 null;
END;

Answer 2

If you want to declare a cursor that is available for a helper procedure, just add another anonymous block:

DECLARE
 cursor cur is select 1 from dual;
BEGIN
 DECLARE
  procedure foo as begin null; end foo;
 BEGIN
  null;
 END;
END;