recall statement not showing all my session's successful statements

[joel C]

The recall statement CTL+E seems to just shows the successful sql statements of my individual session and not across my sessions.
I am using PL/SQL Developer
Version 7.0.0.1063 (MBCS)
01.32374 - 50 user license
Windows XP version 6.0 (build 6002) Service Pack 2

Is there anyway to change this behaviour so I get all sql statements I submitted regardless of the sessions of schemas and instances I connected to before every time ? I think maximum limit is 1000 lines, right ?

Currently I have to log on to the schema/instance session to recall the sql statements I ran before.

 

[Marco Kalter]

If you right-click on the list you can switch between "Current user" and "All users".

 

[joel C]

Thank you so much Marco for your very quick response. Unfortunately I didn't get an email of the update so I actually found out myself this morning that simple right click did the trick and was going to post my answer.

I have a new question. My recall history was actually screwed up yesterday when I up the recall statements to more than 1000 lines. It clocked a long time and when it came back, my PLSRecall.dat was gone !

I had a saved profile from 2011 and copy that old PLSRecall.dat over to the recall directory and it was of no help.

This morning, to my amazement, all my sql history came back so it must have saved the recall stmts somewhere not in the place shown in the recall stmt.

I am scheduled to upgrade my PC next month. How do I retain all my PL/SQl developer settings, including the valuable recall stmts to apply after my new PL/sql developer reinstall ?

 

[joel C]

OK, I found the answer is to export my Vista register entry for PL/sql developer.

 

[joel C]

Marco, I thought I have the answers. But not quite. I can export and import my PL/sql developer settings. I don't think the settings contain the recall statements though. From the sql window ctl+e and right click, I can export all the statements to .csv file.

But is there a way to import the recall statements from a previously export .csv file into my new PL/sql developer install ? I have over 500 lines and I know maximum is 1000 lines.

I can certainly copy/paste from my .csv file but having them in recall statement feature is much nicer.

 

[Marco Kalter]

You can only copy the complete recall buffer from one PC to another. The file is located here:

%APPDATA%\PLSQL Developer\PLSRecall.dat

(e.g. C:\Users\\AppData\Roaming\PLSQL Developer\PLSRecall.dat)

 

[joel C]

Thanks Macro. I actually crashed that data file the day before yesterday when I tried to up the recall stmts to more than 1000 lines !
PL/sql developer wiped out the PLSRecall.dat file at the time for some reason.

So I lost the original most recent PLSRecall.dat file. I replaced it with a 2011 backup of my user AppData and it still didn't work until the next day when the PC reboots.

Any insights into how I could have wiped out the PLSRecall.dat file so easily the day before yesterday ? I did had it opened in windows explorer and view it on ultraedit at the same time at one point.

 

[Marco Kalter]

I'm not sure how that could happen. We have not received any similar problem reports before.

 

[joel C]

Macro, thank you for your help. I have put a reminder to copy out the PLSRecall.dat file the day before my new PC station installation.