Recent content by MartinF

Hi, we are using PL/SQL Developer version 15.0.4.2064 and recently one of our developer got a strange problem with explain plan. I was able to reproduce it. 1- Create a new dummy table: create table test_date(col1 number, col2 date); 2- In SQL Window run the query select col1,col2 from...

Hi, The beautifier is not formatting correctly in version 14.0.6. It was working correctly in version 14.0.4 Beautifier in 14.0.4 begin if p_param1 = 1 then open v_cur_select1 for v_select_1 using 1, 2; else open v_cur_select1 for v_select_1...

Hi, I am getting an error when using substitution variable in SQL Window. When running the following command in SQL Window GRANT SELECT ON acpnuxeo_ogi.hierarchy to &tst.nuxeo_ogi; I am getting the following error: ORA-00933: SQL command not properly ended When running exactly the same...

Hi Marco, Thank for the answer. Maybe it could be a good idea in future version of PLSQL Developer to add this functionality also when writing a query statement to select multiple column. Regards,

Hi, any news about this problem? I would like to use this functionnality to select multiple column when writing my query but it don't seem to work. Regards,

Hi, I am trying to set plsql developer to use user specific plugins so everyone that log on the PC will have their own plugins and config. I actually have some problem with the plugin and I don`t know if the problem is related to PLSQL Developer or if it's a programmation problem with the...

Hi, I am working with release 10.0.4.1708 and I noticed a problem with Cut & Paste. It don`t seem to work from Report Windows. Open the Initialization Parameters report (Menu Reports-DBA-Initialization Parameters) and hit enter to retrieve all parameters. Select something in it. Do Ctrl+C to...

At the bottom of the product info page we can see this:

Hi, After pressing your shortcut key to display the template list, press TAB and the focus should go to the template list allowing you to use only the keyboard without using the mouse. hope it help you

Hi, I am using PLSQL Dev 9.0.6.1665 and I just notice something strange in command window. Here is some sample code to reproduce the problem. Open a command window and create the following table. create table test_mfa(col_1 number,col_2 varchar2(100),col_3 date); insert into test_mfa...

The option was not enabled. After setting the option it's now working correctly. Thank for your help.

Hi, since upgrading to version 9.0.6.1665 I am no longer able to see grants in the object browser for other schema when i am logged with SYSTEM account. Is it a bug or if there is some setting to solve this problem. This was working fine in version 9.0.3.1641

Hi Marco, I just solved my problem. Error seem to occur when using my 10g client. I installed 11g client and everything work fine. Regards, Martin

Hi, I am working with PLSQL Dev 9.0.3.1641 on Windows 7. When querying some table that contain AQ type column, PLSQL crash. I tested it on WinXP with same version of PLSQL Dev and it work fine. Here is the code to reproduce it if you want to try it begin sys.dbms_aqadm.create_queue_table(...

Hi, I know there is an Oracle bug with 64 bits OS when using 32 client application (Metalink note 334528.1). By default 32 bits application is installed in folder c:\program files (x86)\.... and Oracle have some problem with folder that contain parenthesis. You can try reinstalling PLSQL Dev...