Re: Weird listbox issue (Gupta(SqlWindows), Oracle)

On 2 Gruo, 18:32, Shakespeare <what..._at_xs4all.nl> wrote:
>
> Actually, I think it IS the best thing. Better than cluttering your code
> with '""||() and so on... Views are for free, you don't have to pay for
> them...
>
> And instead of testing all kind of modifications to your code, I suggest
> you try to find the difference in the databases. It can't be an Oracle
> bug, for it does work in one of the databases.
>
> I would perform these queries in SQL Plus and check for the differences
> in the result set (null values, lengths, number of records returned)
>
> Shakespeare
>

It's not the matter of price. For the fast solution, we created some views, but they are simply not the best sollution. Our software is huge and creating dozens of views just to represent simple cumulated select data (e.g. for a filter listbox) is not practical and time consuming, especialy for places with already existing code. Writing queries in Pl/Sql Developer (or SQL Plus - doesn't matter which one) is no help here because I can't recreate this situation - data is selected well in both databases.

Comparing db parameters is the only step I see for further checking. But taking in mind that there are more than 250 db parameters (of course, not each is of the matter or may differ), but lets say I'll find 30 parameters that differ and looks potentialy important. How to know which one(s) is(are) faulting data capture? I hoped someone would have any idea or give a direction what to look for/base on - charsets, nls settings, cursor sharing, oracle version difference in dbs, server setting differences (if different servers), etc? Besides, as I have mentioned, problem occurres on the real database with real data where we have limited access and have to make requests to the client for exact information we need. Well, the burocracy... Ok, I'll try getting all the parameters from both dbs tomorow, see what differs and write news here. Hope, then there would be some ideas of what could be wrong.

Thank's for cooperating. :)

MVk - Monika V. kycka

ps. Ah.. And I almost forgot! Data is the same in both databases as there was dump created from real db and imported to test db. ps2. I'm just a programmer and db or server administration is not my field. That's why I would be greatfull for any help. :] Received on Tue Dec 02 2008 - 12:08:10 CST