PLS-00510: Float cannot have scale



PLS-00510: Float cannot have scale..

Answer / guest

Cause: When a FLOAT variable was declared, its precision and
scale were specified, as shown in the following example:
DECLARE Salary FLOAT(7,2); However, a scale for FLOAT
variables cannot be specified; only a precision can be
specified, as in salary FLOAT(7);

Action: Remove the scale specifier from the declaration, or
declare a NUMBER variable instead.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02019: mv references another mv in FROM clause

1 Answers  


ORA-12495: cannot disable an enabled level, category, or release category

1 Answers  


ORA-13906: The tablepace is not of the right type.

1 Answers  


QSM-02059: join may produce duplicate rows in mv

1 Answers  


TNS-00021: INTCTL: missing INTERCHANGE_DATA in INTCHG.ORA

1 Answers  






ORA-02260: table can have only one primary key

1 Answers  


ORA-02174: Missing required thread number

1 Answers  


ORA-25450: error string during evaluation of rule set string.string

1 Answers  


ORA-38774: cannot disable media recovery - flashback database is enabled

1 Answers  


ORA-03213: Invalid Lob Segment Name for DBMS_SPACE package

1 Answers  


NZE-29105: Cannot export PKCS #12 wallet.

1 Answers  


DRG-10303: could not queue given commands to be processed

1 Answers  


Categories