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

TNS-00287: Min Connect Time (secs) : number

1 Answers  


NNL-00271: Default domain is now "string"

1 Answers  


ORA-24365: error in character conversion

1 Answers  


ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags

1 Answers  


ORA-25265: specified signature for a queue which does not support reciever non-repudiation

1 Answers  






ORA-14021: MAXVALUE must be specified for all columns

1 Answers  


ORA-32142: maximum number of iterations exceeded

1 Answers  


ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

1 Answers   ABC,


ORA-23386: replication parallel push cannot create slave processes

1 Answers  


ORA-12085: materialized view log on "string"."string" already has object id

1 Answers  


ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

1 Answers  


ORA-29950: warning in the execution of ODCIINDEXMERGEPARTITION routine

1 Answers  


Categories