Page 1 of 1
problem reading data from oracle through sql builder
Posted: Thu Dec 15, 2005 3:16 am
by sekr
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 .
Posted: Thu Dec 15, 2005 3:28 am
by ArndW
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?
Posted: Thu Dec 15, 2005 3:50 am
by sekr
its not working ! i had tried ..
Posted: Thu Dec 15, 2005 4:42 am
by ArndW
What is wrong with the generated code?
Posted: Thu Dec 15, 2005 4:50 am
by loveojha2
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.
Posted: Thu Dec 15, 2005 5:17 am
by srinagesh
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