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-06975: X.25 Driver: connect to host failed

1 Answers  


ORA-13008: the specified date format has an invalid component

1 Answers  


PLS-00314: TABLE declarations are not allowed as PL/SQL local variables

1 Answers  


KUP-04047: error parsing record from external data source

1 Answers  


ORA-16735: Error executing dbms_logstdby.unskip_error procedure

1 Answers  






RMAN-06438: error executing package DBMS_RCVMAN in string database

1 Answers  


TNS-00501: Cannot allocate memory

1 Answers  


ORA-38424: no attribute set currently assigned to the expression set

1 Answers  


ORA-12803: parallel query server lost contact with another server

1 Answers  


ORA-33068: (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.

1 Answers  


LPX-00003: duplicate entry in hash table

1 Answers  


ORA-02365: error seeking in file: string

1 Answers  


Categories