Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have one problem that is driving me nuts. Since I have very limited knowledge in SQL, maybe you guys could help me out here.
I have an ODBC connection with a oracle system, and it is working just fine with every select i am making.
But, when trying to load this table, it gives me a error connector reply: *** message.
Above some images of what is happening.
1. I open de connection and see the table i'm about to load:
2. When I try to load everything, no good:
3. Curiosly, when I load only the "text" values, the load executes well.
4. But when I try to load VALORH and VALORD, it doesn't load at all.
I have already tried to do a SQL SELECT *, but, again, resulted in the same error
Anyone could help me?
Thanks a lot!
Hey Ronny,
Yes, no success, though...
Thanks!
Hey Clever,
Indeed, it is actually a view, not a table.
And you're right again - it is using some stored procedures to its generation. You think it has anything to do with that?
Thanks!
You should turn on ODBC trace and do a reload. Then you can have a look at the trace log and possibly attach this for us to inspect. Here you will find the exact problem at the ODBC level.
yes, I think that´s could be the main issue.
Can you test your view without the procedure call? Just a test