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 .
problem reading data from oracle through sql builder
Moderators: chulett, rschirm, roy
problem reading data from oracle through sql builder
In Adv Thanks
---------s
---------s
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
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