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

PLS-00337: "string" matches too many object table aliases

1 Answers  


KUP-04067: internal error allocating handle type string

1 Answers  


ORA-01670: new datafile string needed for standby database recovery

1 Answers  


ORA-12717: Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists

1 Answers  


SQL*Loader-00408: Physical record stack overflow

1 Answers  






PLS-00320: the declaration of the type of this expression is incomplete or malformed

1 Answers  


DRG-12003: Please enter username for this FTP server:

1 Answers  


ORA-28543: Error initializing apply connection to non-Oracle system

1 Answers  


LPX-00284: namespace prefix to NULL URI is not allowed

1 Answers  


LFI-00139: Option string cannot be used with option string in calling string.

1 Answers  


PCC-00045: %s clause inappropriate at line number in file string. Ignored.

1 Answers  


PCC-02389: Arrays not allowed as input bind variables in SELECT list

1 Answers  


Categories