Saving SQL Scripts fails
463698Nov 8 2005 — edited Dec 15 2005Hi,
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