Hi Experts,
I faced below error when executing the proc
ERROR at line 1:
ORA-12801: error signaled in parallel query server P009, instance
db352.mbsinsight.com2pvhe2 (2)
ORA-01722: invalid number
ORA-06512: at "SCHEMA_NAME.PRC_NAME", line 59
ORA-06512: at line 2
this procedure will insert the data to target from source where both target and source have around 32 columns.(consists of differnt data types eg DATE,NUMERIC, VARCHAR etc)
When i got this error i did an initial investigation whether the data types of columns in target or same to source or not, I did not find any difference.Understood there should be a data issue which should be non numeric coming from source and causing the issue,
Below is the part of code where exactly it gave error
execute immediate '
CREATE TABLE orders TABLESPACE business PARALLEL NOLOGGING COMPRESS FOR ALL OPERATIONS
PARTITION BY RANGE (txn_date) INTERVAL (numtoyminterval(3,''MONTH''))
(PARTITION p1001 VALUES LESS THAN (to_date(''20080101'',''yyyymmdd''))) AS SELECT * FROM new_orders';
The incremental data gets loaded s on daily basis to New_orders (client file - data is loaded through tool into this table)
....With new data Orders table will be get created.
Because of client mistake etc column X is loaded with varchar data instead of numeric.
Now Want to know to identify quickly which Numeric data type columns in new_orders has non numeric data
Thanks,
Shiva
Message was edited by: Shiva_madhav