My impression was always - you'll need 32 bit oracle client for 32 bit plsqldeveloper version and 64bit oracle client for 64 bit plsqldeveloper version, isn't it so?
Regards
Maxim
Hi, Marco, sorry - probably i was unclear. We observe following behaviour with plsql developer:
If user supplies any query (regardless - based on views, tables, or whatever) - for user supplied version we see 3 OCI Calls in a sequence:
OCIStmtPrepare
OCIStmtExecute
OCIStmtFetch2
Immediately...
Marco, i need to reiterate on this topic. I have attached a Frida script to plsql developer instance and traced the execution. What i see in the trace - for each of my authorized query plsql developer executes "unauthorized" version. It means, i have following sequence of steps:
[OCIStmtPrepare]...
Thanks for fast reply. Your suggested setting for view ddl - changes (in our setup) load of the (problematic) view content to happen instantly, again - thanks a lot!
Regards
Maxim
I think, i have an issue with possible bug - if i select fully qualified view name in the sql window (maybe either a view name in own schema) - and click on the menu point - view "...my view..." -> view - then by some views it loads extremely long time the content of view into sql window. I...
Why do you think the current behaviour is incorrect? If i understood it properly - it is perfectly aligned with the visibility rules - if you as userA run the query "select id from test_table" - you'll either get error, because the table is in another schema? For that reason, you can't right...
Regarding your second question - i think the most similar approach would be to put the query 2 (or more if required) times into sql window, run it and then select 2 result set tabs (by Ctrl+LeftClick on the tab) - it brings both tabs in foreground, both result sets can be fetched then separately...
Editing the procedure in broader sense might include changes to api (renaming of parameter, complete new parameter and so on). To reflect such changes - the test window should completely be reloaded discarding non present parameters and adding new parameters. As of know - i don't think, such...
I just published a prototype for unwrapper addon based on excellent luaplsql plugin by Nodir Temirkhodjaev -https://github.com/Maxim4711/luaplsql_addons
There is a short README with description how to build it locally, alternatively - i provided a zip release for 64 bit version. I somebody...