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-03290: Invalid truncate command - missing CLUSTER or TABLE keyword

1 Answers  


DRG-52112: improper Chinese string string of length number

1 Answers  


ORA-29833: indextype does not exist

1 Answers  


RMAN-00551: initialization of parser package failed

1 Answers  


RMAN-06004: ORACLE error from recovery catalog database: string

1 Answers  






DRG-50943: query token too long on line string on column string

1 Answers  


ORA-00267: name of archived log file not needed

1 Answers  


EXP-00050: Cannot perform Partition Export "string" on non-partitioned table "string"

1 Answers  


ORA-36180: (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.

1 Answers  


RMAN-20502: DELETE EXPIRED cannot delete objects that exist - run CROSSCHECK

1 Answers  


ORA-24003: Queue table index string inconsistent with queue table string

1 Answers  


ORA-12910: cannot specify temporary tablespace as default tablespace

1 Answers  


Categories