Search notes:

ORA-04044: procedure, function, package, or type is not allowed here

The ORA-04044: procedure, function, package, or type is not allowed here is thrown (for example) when trying to use a user defined PL/SQL function to assign a value to a default column:

create table tq84_x (
    id integer,
    val varchar2(5) default dbms_random.string('a', 5)
);
--
-- ORA-04044: procedure, function, package, or type is not allowed here

ORA-04044: procedure, function, package, or type is not allowed here

See also