PLS-00407: '*' not allowed here; a list of columns is required



PLS-00407: '*' not allowed here; a list of columns is required..

Answer / guest

Cause: An asterisk (*) was used as an abbreviation for a
list of column names. However, in this context the column
names must be written out explicitly.

Action: Replace the asterisk with a list of column names.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-35756: (VCTODT02) 'number' is not a valid date because number is out of range for a year.

1 Answers  


ORA-29917: cannot lock a table which gets its rows from a collection operand

1 Answers  


DRG-10507: duplicate index name: string

1 Answers  


SQL*Loader-00624: no terminator found after TERMINATED and ENCLOSED field

2 Answers  


AMD-00115: PROCEDURE string, invalid file handle

1 Answers  






SQL*Loader-00956: Error calling once/data file finishing

1 Answers   Wipro,


ORA-25233: invalid parameter specified for NAVIGATION

1 Answers  


ORA-33046: (XSAGDNGL22) In AGGMAP workspace object, you can specify only one SCREENBY clause.

1 Answers  


ORA-40103: invalid case-id column: string

1 Answers  


IMG-02012: 2FF12 - illegal specification for thumbnail generation

1 Answers  


ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns

1 Answers  


ORA-09843: soacon: Archmon unable to create named pipe.

1 Answers  


Categories