PLS-00245: Formals used in the 'parameters' clause must
appear exactly once



PLS-00245: Formals used in the 'parameters' clause must appear exactly once..

Answer / guest

Cause: There are multiple declarations of the formal
parameter in the PARAMETERS clause. PL/SQL allows only one
declaration of the formal parameter in the PARAMETERS clause.

Action: Correct the PARAMETERS clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00622: Column not found before end of logical record (use TRAILING NULLCOLS)

2 Answers  


ORA-39054: missing or invalid definition of the SQL output file.

1 Answers  


NNO-00303: server "string" started with process ID number

1 Answers  


ORA-09362: Windows 3.1 Two-Task driver unable to deallocate context area

1 Answers  


ORA-32336: cannot use USING NO INDEX to create materialized view "string"."string"

1 Answers  






ORA-13379: invalid index for sub-element to be extracted

1 Answers  


SQL*Loader-00403: Referenced column string not present in table string.

1 Answers  


QSM-02121: set operator in a context not supported for fast refresh

1 Answers  


ORA-06580: Hash Join ran out of memory while keeping large rows in memory

1 Answers  


ORA-40213: contradictory values for settings: string, string

1 Answers  


ORA-12487: clearance labels not between DBHIGH and DBLOW

1 Answers  


TNS-01442: No filtering rules currently in effect.

1 Answers  


Categories