yes, but you have to use FORMS_DDL.
Referencing allows you to create objects that inherit their functionality
and appearance from other objects. Referencing an object is similar to
copying an object, except that the resulting reference object maintains
a link to its source object. A reference object automatically inherits any
changes that have been made to the source object when you open or
regenerate the module that contains the reference object. Any string
expression up to 32K:
- a literal
- an expression or a variable representing the text of a block of
dynamically created PL/SQL code
- a DML statement or
- a DDL statement
Restrictions:
The statement you pass to FORMS_DDL may not contain bind variable
references in the string, but the values of bind variables can be
concatenated into the string before passing the result to FORMS_DDL.