PLS-00227: subprogram 'in' formal string is not yet denotable



PLS-00227: subprogram 'in' formal string is not yet denotable..

Answer / guest

Cause: When the formal parameters of a subprogram were
declared, one parameter was used to initialize another, as
in PROCEDURE my_proc (j NUMBER, k NUMBER := j) IS ... The
first parameter has no value until run time, so it cannot be
used to initialize another parameter.

Action: Remove the illegal formal parameter reference.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00234: error in identifying or opening snapshot or copy controlfile

1 Answers  


ORA-39149: cannot link privileged user to non-privileged user

1 Answers  


ORA-19018: Invalid character in XML tag 'string'

1 Answers  


ORA-00023: session references process private memory; cannot detach session

2 Answers  


ORA-01605: missing numbers in clause "string" of string

1 Answers  






PLS-00140: duplicate external LIBRARY specification in subprogram expression

1 Answers  


ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed

1 Answers  


ORA-31499: null value specified for required parameter string

1 Answers  


ORA-01161: database name string in file header does not match given name of string

2 Answers  


ORA-21560: argument string is null, invalid, or out of range

1 Answers  


NZE-28750: unknown error

1 Answers  


QSM-02057: ROWNUM referenced in mv

1 Answers  


Categories