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-32822: subscriber string is marked for removal

1 Answers  


PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field

1 Answers  


ORA-02331: cannot create constraint on column of datatype string

1 Answers  


ORA-29522: authorization error for referenced name string.string

1 Answers  


LSX-00130: attribute "processContents" has invalid value "~S"

1 Answers  






RMAN-06034: at least 1 channel must be allocated to execute this command

1 Answers  


ORA-23370: table string and table string are not shape equivalent (string)

1 Answers  


ORA-01841: (full) year must be between -4713 and +9999, and not be 0

2 Answers  


ORA-13612: The recommendation action string,string is not valid for task string.

1 Answers  


NZE-29018: The premaster secret contains an incorrect version number.

1 Answers  


ORA-24386: statement/server handle is in use when being freed

1 Answers  


SQL*Loader-00555: unrecognized processing option

1 Answers  


Categories