Recent content by mamv

Hi, This also happened on the previous version, but would love to see it fixed in version 15. When you use a CASE inside an analytic funcion beautifier gives an error: select dummy, ROW_NUMBER() OVER (ORDER BY CASE WHEN dummy = 'X' THEN 1 ELSE 0 END) rn from dual Best, Manuel

The new explain plans after upgrading to 12c were driving me crazy, but after some reading and debugging I found out that PL/SQL Developer is showing inactive steps from the adaptative plan. Example: The Hash join doesn't make any sense. Using the dbms_xplan.display_cursor(format =>...

Yes, I know but yesterday I had no access to the old computer. And I thought it should be straightforward. I opened both files in old computer and I cannot see any information of my fixed users.

Is there any way to backup Fixed Users when changing computer? I copied the default.ini and user.prefs but fixed users got lost. Thanks in advance

Totally agree Maxmix. An option is mandatory.

Thanks Claus, really nice work around. I was looking for this options for ages...

Thanks for the info Marco. But it's a major handicap when you use 3rd party software API's which are wrapped in developemnt, because you can't use code assistance to know the name of the procedures and input/output variables. I think it would be a great addon, that when the the package is...

Hi Marco, I'm not being able to see the procedures of some wrapped packages, in the object browser and in code assistant. Are you aware of any similar problem? I'm able to query all_procedures and all_arguments and see the procedures and arguments of the wrapped package. I can email you the...

Hi Marco, I sent you the email reply last week, do you have any update regarding this bug? Thanks in advance.

Hi Marco, When I try to insert a big varchar2 (with 4000 characters) I'm getting an error: "ORA-01480: trailing null missing from STR bind value". Could you please try the following: 1 - create table test (a varchar2(4000)); 2 - select lpad('A',,'A') from dual; 3 - Open the result of the...

Hi Marco, I'm having exactly the same problem using the large data editor. Bellow you will find the string I'm trying to put on a varchar2(4000) field using large data editor and that triggers the ORA-01480: trailing null missing from STR bind value: BEGIN...

Hi, I found a problem when trying to output a variable of VARCHAR2(4000). Example: CREATE TABLE teste as select lpad('A',4000,'A') text from dual; -- I changed the buffer size in PL/SQL Developer to 10000000 When I run this code: DECLARE l_text VARCHAR2(4000); BEGIN...

Hi, Bellow I will show examples of the 3 most anoying (at least for me :grin:) bugs in sql beautifier I encouter almost in everyday usage. I had them stated on the beta forum, but since it was deleted I feel its my dutty to post them again. Really hope you guys can fix this. Keep up the...

Are you using remote desktop? If yes google for "remote desktop copy and paste not working". I also thought the problem was from pl/sql developer, but if you disable in Remote Dekstop options -> local resources -> untick clipboard, everything works properly (but you will not have the ability...

1 to go... Common guys, I can't sleep at night :).