problem reading data from oracle through sql builder

sekr · Post by **sekr** » Thu Dec 15, 2005 3:16 am

problem in read data from orcale stage !
exp:- after selecting tabel from sql builder .. view data is not showing any data (all connections are prefect).
when i try with customized sql statment i can able to read the data from oracle .

ArndW · Post by **ArndW** » Thu Dec 15, 2005 3:28 am

If you take a copy of the generated SQL from the SQL builder and execute it in your tool of choice (sqlplus, Toad, etc.) does it execute correctly?

sekr · Post by **sekr** » Thu Dec 15, 2005 3:50 am

its not working ! i had tried ..

ArndW · Post by **ArndW** » Thu Dec 15, 2005 4:42 am

What is wrong with the generated code?

loveojha2 · Post by **loveojha2** » Thu Dec 15, 2005 4:50 am

sekr wrote:its not working ! i had tried ..

Can you paste the what error message you are getting when you are doing it from sqlplus.

srinagesh · Post by **srinagesh** » Thu Dec 15, 2005 5:17 am

I guess it has something to do with "fully qualified table name".
The SQL query generated using SQL Builder might be
Select <columns>
From <schemaname>.<tablename>
where <condition>

and the table in that schema might not be having any data.

I know that I am just speculating the cause of the problem. But believe me something this simple is bound to be source of "what seems to be a big problem".

-Nagesh