Toad World® Forums

popup when clicking on Data tab in SB for table with FK

beta .17

[View:/cfs-file/__key/communityserver-discussions-components-files/86/1641.Doc1.docx:320:240]

huh. I have’t been making any changes in the SB code lately. This is the same error message you were seeing in Copy Table Data a month or so ago. I was never able to reproduce it, and as I recall, it went away after you restarted.

Can you turn on spool SQL so I can see what query this is coming from?

This is the last SQL, which seems reasonable since it only happens on table with an FK.

Select count(*)

FROM DBA_CONSTRAINTS
WHERE OWNER = ‘CHX_COMMON’
AND TABLE_NAME = ‘HOST’
AND CONSTRAINT_TYPE = ‘R’;

I can’t reproduce this, Dale. And I don’t know why you would be getting this message, either. This is 64 bit, right?

I’m not sure if it’s relevant, but what is your Oracle client version? Does the error go away like it did before if you restart Toad?

Using 11.2.0.1 client. And, yes, no error after restarting Toad.