PLS-00228: Illegal declaration of variable of type LONG



PLS-00228: Illegal declaration of variable of type LONG..

Answer / guest

Cause: The identifier is a formal parameter which is being
used in the context of a default expression value for a
formal parameter in the same formal parameter list. E.g.:
procedure p(j number, k number := j).

Action: Remove the offending variable definition

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-10845: column string is not indexed

1 Answers  


TNS-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

1 Answers  


ORA-14070: option may be specified only for partitioned indices or with REBUILD

1 Answers  


ORA-02852: Invalid critical-section time out value

1 Answers  






ORA-22627: tc [string] must be that of object/varray/nested table

1 Answers  


IMP-00083: dump file does not contain an incremental export

1 Answers  


SQL*Loader-00655: cannot load object-relational XML attribute using direct path

1 Answers  


O2I-00133: An error occurred for which no message is available

1 Answers  


ORA-25007: functions or methods not allowed in WHEN clause

1 Answers  


ORA-22920: row containing the LOB value is not locked

1 Answers  


ORA-27451: %s cannot be NULL

1 Answers  


Categories