Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-30001: trim set should have only one character

1 Answers  


NNL-00411: Minimum response time: string

1 Answers  


TNS-12601: TNS:information flags check failed

1 Answers  


ORA-07801: slbtpd: invalid exponent

1 Answers  


TNS-00542: SSL Handshake failed

1 Answers  






PCC-01512: Invalid EXEC SQL INCLUDE of file string found at line number in file string

1 Answers  


ORA-39961: message specified was not found

1 Answers  


RMAN-06107: WARNING: controlfile is not current for REPORT NEED BACKUP DAYS

1 Answers  


DRG-10836: field section and attribute section can not be nested

1 Answers  


PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

1 Answers  


PLS-00705: exception 'string' used in expression requiring return type

1 Answers  


NNL-00901: CONTENT ERROR responses sent: number

1 Answers  






Categories