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!

Saving SQL Scripts fails

463698Nov 8 2005 — edited Dec 15 2005
Hi,

I do really like the oppurtinity to store SQL scripts in the repository.

I filled up my repository with a couple of scripts - saving and running worked fine. But now I cannot store any more scripts.

I followed exactly the steps as mentioned in the "HTML DB 2 Day Plus Developer Guide" Chapter 10 (Issue Tracking Application): I click "CREATE" in the SQL Scripts dialog, enter a name for the script, copy the script via clipboard into the large text field, click on "Save" - no reply and the script does not appear in the list of SQL scripts ...

I also tried to run the script immediately without saving it first. The parser accepts the script and asks for confirmation. When pressing "Run" now, I get an NOT-NULL-VIOLATION (german error text below)

[...]
ORA-01400: Einfügen von NULL in ("FLOWS_020100"."WWV_FLOW_SW_RESULTS"."FILE_ID") nicht möglich
Unable to submit the script to run.
[...]

I am using Oracle XE on Win XP SP2, IE 6.0 or Firefox 1.07

Any ideas?

Thanks & Cu
Walter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2006
Added on Nov 8 2005
4 comments
245 views