I am getting a ORA-01438 precision exceeded error no matter what datatype/precision and scale I set in SQL Developer.
Create and Insert script snippet:
CREATE TABLE Product
(
Product_ID NUMBER(38,127),
Product_Name VARCHAR2(255),
Product_Price NUMBER(38,127) NOT NULL,
Product_Weight VARCHAR2(255),
Product_Dims VARCHAR2(255),
Product_Desc VARCHAR2(255),
Warehouse_ID NUMBER(10),
PRIMARY KEY(Product_ID),
FOREIGN KEY(Warehouse_ID) REFERENCES Warehouse
);
INSERT INTO Product (PRODUCT_ID, PRODUCT_NAME, PRODUCT_PRICE, PRODUCT_WEIGHT, PRODUCT_DIMS, PRODUCT_DESC, PRODUCT_QUANT, WAREHOUSE_ID)
VALUES ('101', 'plant pot', '23.99', '6lbs', '4x4x6', 'clay plant pot', '22', '10');
Data types or precision/scale are not my issue because my create table statements successfully executed and I have checked my datatypes and they match any referenced table/column, etc. My precision and scale are set to the maximum allowed characters on every column and I tested inserting a row with ONE character for each field. Yet I receive an error that I have exceeded the limit.
That snippet is just one of MANY attempts at entering the data. Some of the data types are NUMBER fields; I know the string literal quotations are not necessary and I have tried entering them with and without the quotes. I tried inserting 1 single character or digit in each appropriate field and it still failed with the same error.
What can I do to solve this?