Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-31649: Master process string violated startup protocol.

1 Answers  


ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

1 Answers  


ORA-01414: invalid array length when trying to bind array

1 Answers   Gucci,


RMAN-06429: %s database is not compatible with this version of RMAN

1 Answers  


PLS-00606: cursor subquery is not supported on client side in this release

1 Answers  


ORA-02034: speed bind not permitted

1 Answers  


NZE-29002: SSL transport detected invalid or obsolete server certificate.

1 Answers  


PCB-00220: Invalid scale specified in EXEC SQL VAR statement

1 Answers  


ORA-06705: TLI Driver: remote node is unknown

1 Answers  


ORA-14605: Name missing for subpartition / lob segment in template

1 Answers  


ORA-13296: incorrect coordinate system specification

1 Answers  


ORA-36266: (XSCGMDLAGG00) Invalid context for the AGGREGATION function

1 Answers  


Categories