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

ORA-01291: missing logfile

1 Answers  


ORA-28276: Invalid ORACLE password attribute.

1 Answers  


LFI-00126: Record format can only be one of Fixed or Variable.

1 Answers  


ORA-30569: data type of given column is not supported in a log group

1 Answers  


ORA-12538: TNS:no such protocol adapter

1 Answers  


ORA-01126: database must be mounted in this instance and not open in any instance

1 Answers  


ORA-16104: invalid Logical Standby option requested

1 Answers  


AMD-00115: PROCEDURE string, invalid file handle

1 Answers  


ORA-23473: replication RPC processing for "string"."string" is disabled

1 Answers  


ORA-19712: table name exceeds maximum length of string

1 Answers  


ORA-22919: dangling REF error or lock object failed for no wait request

1 Answers  


TNS-12615: TNS:preempt error

1 Answers  


Categories