PLS-00712: illegal option for subprogram string



PLS-00712: illegal option for subprogram string..

Answer / guest

Cause: Only top level subprograms or subprogram declarations
in PACKAGE or TYPE specifications are allowed to have the
options DETERMINISTIC or PARALLEL_ENABLE. For example, this
error would be raised if the options are used in PACKAGE or
TYPE body.

Action: remove the option.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32773: operation not supported for smallfile tablespace string

1 Answers  


RMAN-08160: script commands will be loaded from file string

1 Answers  


ORA-38766: cannot flashback data file string; file resized smaller

1 Answers  


LPX-00260: invalid xml:space attribute declaration

1 Answers  


ORA-38307: object not in RECYCLE BIN

1 Answers  






IMG-00803: invalid attribute value

1 Answers  


ORA-01172: recovery of thread string stuck at block string of file string

1 Answers  


ORA-12823: default degree of parallelism may not be specified here

1 Answers  


ORA-29553: class in use: string.string

1 Answers  


SQL-02118: Invalid row for a WHERE CURRENT OF operation

1 Answers  


ORA-09203: sfofi: error opening file

1 Answers  


ORA-06133: NETTCP: file not found

1 Answers  


Categories