I have logged in with Tora for postgres , with a schema ,but am not able to see the tables list, schema browser was showing Grey color, how to resolve?
Keep Alive with Oracle database is not working
Failure to execute a fully parsed multile lines SQL request
Failure to update values with mixed cases field name through HMI
Hi is my question unappropriate ? Isn't it the right place to ask ?
Hi Everyone. We intend to integrate the launch of TORA to our personal remote access control application using the various parameters we need to automatically launch TORA and open the connection. Could anyone tell me if it is possible to do so ? Is there a way to use command line script to send these parameters to the TORA's connection interface ? Thanks for your replies. Best regards Ben.
Hi all, I installed Tora.3.2.146.Release.64bit and cannot figure out how to use the oracle wallet with TOra. The wallet is configured and works with sqlplus. In TOra I can see connections defined in tnsnames.ora, including those associated with wallet entries. If I put / (forward slash) as user name and leave the password box empty, the connection attempt fails, complaining about the empty password. I also tried leaving the user name empty, but also to no avail. Any suggestions? Best /me
High cpu time when showing columns list of a table with oracle 12c
Disconnecting from database closes whole app
probably fixed by last commit. long story short - tora cached names of all db objects for every connection. When you closed the app, before this bg task was done, the app crashed. PS: use github for reporting bugs.
Disconnecting from database closes whole app
Unable to show data when using Oracle Data Type BINARY_DOUBLE
The order of the selected columns is important, and currently (version 3.2) wrong. As a consequence, the right hand side of the Open Cursors (sql text, explain plan, ...) remains empty or causes errors. Easily solved by using the following query: select SQL_Text SQL , p.child_number as chld , c.SQL_ID as sqlid , CURSOR_TYPE , LAST_SQL_ACTIVE_TIME , SQL_EXEC_ID from v$open_cursor c join v$sql_plan p on c.ADDRESS = p.ADDRESS and c.HASH_VALUE = p.HASH_VALUE and c.sql_id = p.sql_id and p.id = 0 where...
The order of the selected columns is important, and currently (version 3.2) wrong. As a consequence, the right hand side of the Open Cursors (sql text, explain plan, ...) remain empty or cause errors. Easily solved by using the following query: select SQL_Text SQL , p.child_number as chld , c.SQL_ID as sqlid , CURSOR_TYPE , LAST_SQL_ACTIVE_TIME , SQL_EXEC_ID from v$open_cursor c join v$sql_plan p on c.ADDRESS = p.ADDRESS and c.HASH_VALUE = p.HASH_VALUE and c.sql_id = p.sql_id and p.id = 0 where sid...
When I click on an already defined connection for Tora v3.2.82 on 64bit Win7 then an error popup appears: "Connection provider not loaded: MySQL" How do I fix this?
Cannot set date format for databases other than Oracle.
Sorry Ivan, only now I saw your message. But I hate patching on GitHub, let alone patching a "partial" project. What does that mean?
Version: v3.2-82-gd124b51a OS: Windows 10 Enterprise 1709 I'm missing the list of table columns in the filter dialog of table data. Please check the attached screenshots. Is it possible to solve that problem? https://sourceforge.net/p/tora/bugs/901/
Filter dialog doesn't show columns
cau you please turn it onto a patch? PS: I moved the project partially onto Github.
cau you please turn it onto a patch?
To get a result that is readable (the descriptions should be used as column headers): SELECT osid W_PROC, i.instance_name INSTANCE, 'INST #: '||instance INST, decode(blocker_osid,null,'',blocker_osid)||'@i:'||blocker_instance BLOCKER_PROC, num_waiters waiters, decode(p.spid,null,'', p.spid)||' from Instance '||s.final_blocking_instance FBLOCKER_PROC, p.program image, wait_event_text wait_event, wc.p1 p1, wc.p2 p2, wc.p3 p3, in_wait_secs Seconds, time_since_last_wait_secs sincelw, chain_id ||': '||chain_signature...
You're right it does not work anymore. Can you pls report it on GH. thanks.
Just downloaded and tried both .zip and .msi of Tora 3.2.70 64bit release. Edit > Preferences... doesn't do anything, doesn't open any Preferences dialog. I'm using Windows 10 Enterprise 1607.
Debuger feature is not suported yet.
I've installed TOra 3.2 on a windows 10 machine with Oracle 10 client. I can work with it without problems but I don't have the pl/sql debugger tool on my TOra, so I can't debug my packages. Is something I've missed in the configuration of TOra? is it a bug?
I've installed TOra 3.2 on a windows 10 machine with Oracle 10 client. I can work with it without problems but I don't have the pl/sql debugger tool on my TOra, so I can't debug my packages. Is something I've missed in the configuration of TOra? is it a bug?
I've installed TOra 3.2 on a windows 10 machine with Oracle 10 client. I can work with it without problems but I don't have the pl/sql debugger tool on my TOra, so I can't debug my packages. Is something I've missed in the configuration of TOra? is it a bug? ![https://ibb.co/hCDtm5]
I've installed TOra 3.2 on a windows 10 machine with Oracle 10 client. I can work with it without problems but I don't have the pl/sql debugger tool on my TOra, so I can't debug my packages. Is something I've missed in the configuration of TOra? is it a bug?
The path for connector should contain the library named: libmysql.dll (for example: F:/MySQL Connector C 6.1/lib) Also under Tora installation there should by file sqldrivers/qsqlmysql.dll
I have just installed Tota 3.2, and I can't connect to Mysql I received the message connection provider not loaded: Mysql My operating system is windows 10. In the same machine with Tora 2.1.3 I have connected without problem. I have installed MySql Connector C 6.1 ang I configured In Tora preferences the sql path C:/Program Files/MySQL/MySQL Connector C 6.1/. I will appreciate any help Thanks
Check HKEY_CURRENT_USER\Software\TOra\TOra3
Where exactly in Registry are the Tora preferences stored (in Windows 7)? Thank you Thomas
Where exactly in Registry are the Tora preferences stored (in Windows 7)? Since
Where exactly in Registry are the Tora preferences stored? Since
Yes. go to files section, and you'll find a .zip archive there.
Hi, Is possible to install TOra in portable mode? Thanks!
PL/SQL editor does not save, nor allow compilation.
Thanks Gerard
Edit -> Preferences -> Database Settings -> Oracle -> Default Date Format ?
I would like to change day display format by default (YYYY-MM-DD) to DD/MM/YYYY....
I confirm. Now is ok. I can select anything from system and any user tables.