Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem saving SQL Scripts

701054May 12 2009 — edited Aug 21 2009
Has anyone has this problem:
1) I log onto my database (Oracle XE 10.2.0).
2) I open a SQL Script that I previously created and saved. The script is about 1700 bytes.
3) I edit the script. I run the script. I click "Edit Script" button on results screen.
4) Everything is fine.
5) I repeat these steps (1-4) 10 or 20 times and then all of a sudden all edits to my script stop saving.
A) When I run the script without explicitly saving the script, it runs the unedited version of the script.
B) When I explicitly save the script, the edits do not save.
C) If I log off the database and back on again, the effects are the same (beginning here with "5)" from the get-go).
D) I I log off the database, shut down IE 7.0, reboot IE, log back on to the database I begin here at "5)" again.
E) I mark all my script and copy it to clipboard. I replace script with 3 bytes: "aaa". I click "Save". The three bytes save.
F) I replace the 3 bytes with my original 1700 bytes of code. The 1700 bytes do not save; only the three bytes remain.
6) In summary, I would ask, "Is there a size limit to the amount of SQL script you can save using this application?". However, the problem with this question is that everything worked fine for me for one and one-half hours of using the app.

I will go now to reboot my machine to see if that resolves it.

I will report back here with the results of that experiment.

Anybody has any insight, I would be grateful 'cause this is frustrating!!

Thank you,
Mike Kemp
St. Petersburg, FL
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2009
Added on May 12 2009
6 comments
2,227 views