PLS-00120: inappropriate argument in OPEN statement



PLS-00120: inappropriate argument in OPEN statement..

Answer / guest

Cause: The asterisk (*) option was used in the argument list
of a SQL group function other than COUNT. For example, the
code might look like SELECT SUM(*) INTO emp_count FROM emp;
-- should be COUNT(*) Only COUNT permits the use of the
asterisk option, which returns the number of rows in a table.

Action: Remove the asterisk option from the argument list
and replace it with an expression that refers to one or more
database columns.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28843: Operating system error while creating/opening file

1 Answers  


ORA-12591: TNS:event signal failure

1 Answers  


ORA-28237: seed length too short

1 Answers  


DRG-11607: URL store: access to string was denied due to garbled response

1 Answers  


ORA-07605: szprv: $ASCTOID failure

1 Answers  






ORA-29535: source requires recompilation

1 Answers  


ORA-33429: (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.

1 Answers  


ORA-23602: Invalid streams process type string

1 Answers  


ORA-02774: Invalid request list latch time out value

1 Answers  


ORA-32120: Buffer size is less than amount specified

1 Answers  


ORA-04068: existing state of packagesstringstringstring has been discarded

1 Answers  


ORA-13295: geometry objects are in different coordinate systems

1 Answers  


Categories