For a database with European NLS Parameters, an invalid date error appears when trying to generate data using the Internal data engine.
Toad generates insert statements that won't work on non-english NLS parameters for DATE columns.
For example:
INSERT INTO TEST1 (
BIRTHDATE,
) VALUES (TO_DATE('15-APR-1965', 'DD-MON-RRRR')
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center