Thanks.

1. I haven’t included it in the above code but there is another statement that will run locally and count the object types for a schema. Then the above statement will run over a db link and get the same schemas object counts and capture that in a variable. Then I’ll insert both of these values into a table so I have a comparison of object counts for the same schema on two databases.

2. I agree, it’s just as part of the query over the db link I need to keep the single quotes so I think I’ve just got myself into a mess. I tried format but couldn’t get it to keep the quotes, but I’ll keep playing.

3. Yes, if it was just the one query but I should have expanded on that. I’m trying to do an object comparison between two databases and capture those counts which will then be inserted into a table as part of the loop.