Invalid script created when generating Insert Statements using the Export Data functionality</ (4246970)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Invalid script created when generating Insert Statements using the Export Data functionality
Description

When exporting data (insert statements) from a table which includes ‘default ' ' not null,’ in the DDL, the statements are not created correctly. When you try to run the script into the table, it is unsuccessful as the spaces in the null values are incorrect.
1. In the editor, run:   select table_name.*,rowid from table_name;
2. Click the ‘Export Data’ button.
3. Export format = ‘Insert Statements’
4. Tick ‘Display all results in grid’
5. Untick ‘Include Null Text’
6. Export the data
In the resulting script, the null values appear as follows, with no spaces in the null entry:

Insert into TABLE_NAME
   (C1, C2)
Values
   (4613225644, '');

The null value is ‘’, that causes an error when you try to run the generated script into the table.

If ‘Include Null Text’ is ticked, and ‘Display all results in Grid’ is unticked, then the null value is generated correctly, with spaces for the null entry:

Insert into TABLE_NAME
   (C1, C2)
Values
   (4613225644, '          ');

However, it doesn't necessarily make sense to tick the ‘Display all results in grid’ option, and also this didn’t happen in Toad 10.5.
Resolution

WORKAROUND:
This is fixed in Toad v11. (currently in beta - http://toadfororacle.com/beta.jspa)
STATUS:
Waiting for fix in a future release of Toad for Oracle
Defect ID

ST82137

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title