Toad World® Forums

Copy Data and Compare Data insert both return error

Can not access DML array as a single value

I get this error during Copy data to another schema, and in a Compare Data - row-by-row using Insert Select “source only” data into Target.

In 12.11 GA

And the All Differences tab - update target with selected rows from source

I get the ORA- error below and with the spooled SQL

I tried the update statement from the Editor and works fine.

UPDATE FIRM_COMM.SERVICE SET RECORD_MODIFICATION_USERNAME = ‘dnamasterose’, DB_ACTION_USERNAME = ‘SVR$MAINT_FC’ WHERE SERVICE_ID = 1042;

Error: ORA-24333: zero iteration count

This is fixed for next beta in Compare Data, but I don’t get any error in Copy Table to Another Schema. Do you have any more details about it?

I get the error in Copy Table Data when destination connection differs from source connection.

That is how I tested it. You didn’t happen to have array size set at 1, did you? I did notice a problem with that, but it gave a different error.

All I changed was the Destination connection. The array size is 500

hmm. Can you send me the table DDL and data? if the data is sensitive, that’s OK, I’ll stick some random data in there.

Happens for any table I've tried.

CREATE TABLE test_copy AS SELECT * FROM dual;

The copy from db1 to db2 gives this error:

7/26/2017 2:37:03 PM: THERE WAS AN ERROR EXECUTING THE FOLLOWING QUERY

Insert into DARDBA.TEST_COPY
(
DUMMY
)
values
(
:v0
)

Error Message:
Can not access a DML array as a single value
7/26/2017 2:38:35 PM: * Process Aborted by User *
7/26/2017 2:38:36 PM: Copy Table Data27 (Copy Table Data) finished.

These are the settings:

What Oracle client version are you using, Dale? I still can’t reproduce this.

11.2.0.1

I updated to the latest beta today, and just now tried again and I can no longer reproduce it. I started up the 12.11 GA and cannot reproduce there either, so I"ve no idea what triggered this. Copy Data is not something I do very often, but if the error happens again, I’ll let you know…