Toad World® Forums

Cross-connection SQL Editor -- can't find database object

Hi,

when I run the query below search data from Oracle DB in Cross-connection sql editor ,

select count(1) from SCBECBHV (RENJERRY), RENJERRY.RENJERRY.DIM_ANSWER;

It shows error:

Category Timestamp Duration Message Line Position
Error 1/2/2016 10:49:05 AM 0:00:00.661 Can’t find database object SCBECBHV (RENJERRY), RENJERRY.RENJERRY.DIM_ANSWER 1 0

However, I run the query below in sql editor, there is no error.

select count(1) from DIM_ANSWER;

Could anyone help me to solve it?

Thanks,

Try removing the single apostrophe from your original query. I think it is messing up on the renjerry’.renjerry…

I have no issues with the Cross Query Below. i don’t think taking out the apostrophe will help. That is needed to identify the connection. Try adding an alias on the table. Don’t use numbers as an alias as it looks like above in your sample sql.

SELECT COUNT(*)

FROM SMOKETEST_ORACLE11 (QUEST_DEV), QUEST_DEV.QUEST_DEV.ORDERS ORDERS

Thank Debbie and Mark for your help.

I replaced with ETL_ECCOINT instead of RENJERRY. It works now.

select count(1) from SCBECBHV (RENJERRY), RENJERRY.ETL_ECCOINT.DIM_ANSWER;