I am in the process of porting an application to Oracle and have as a start downloaded 10g. I have been able to run scripts for a while, but now I am unable to run anything - no matter what user I login as. The errorcode is as follows:
ORA-01400: cannot insert NULL into ("FLOWS_020100"."WWV_FLOW_SW_RESULTS"."FILE_ID")
Unable to submit the script to run.
(If I instead of the script try to run my code as a SQL Command, the result is: "The requested URL /apex/wwv_flow.show was not found on this server ").
Without having seen your script, it is obvious that you are inserting a record in to the FLOWS_020100.WWV_FLOW_SW_RESULTS table. The FILE_ID column has a NOT NULL constraint and you are attempting to insert a record with NULL in that column.
You'll have to do some debugging of your script to find out why you are attempting to insert NULL into this column when that operation is not allowed.
peter.koch.larsen@gmail.com wrote:> I have been able to run scripts for a while, but now I am unable to run> anything - no matter what user I login as. The errorcode is as follows:>
(If I instead of the script try to run my code as a SQL Command, the> result is: "The requested URL /apex/wwv_flow.show was not found on this> server ").>
How were you running the scripts before? Via SQL*Plus? The error you mention seems to point to a munged HTMLDB/Apex install. When did it all stop working?
Peter Koch Larsen 8 May 2006 13:09:04 [ permanent link ]
gazzag wrote:> peter.koch.larsen@gmail.com wrote:> > I have been able to run scripts for a while, but now I am unable to run> > anything - no matter what user I login as. The errorcode is as follows:> >
(If I instead of the script try to run my code as a SQL Command, the> > result is: "The requested URL /apex/wwv_flow.show was not found on this> > server ").> >
How were you running the scripts before? Via SQL*Plus? The error you> mention seems to point to a munged HTMLDB/Apex install. When did it> all stop working?
Hi Gazzag
Well... I ran the scripts via the HTML-interface. Why/when it stopped working, I do not really know. Even after reinstalls (where I had to manually remove files entries from the installed directory and entries in registry in order to properly remove the product), I have not been able to run scripts. Also, even simple SQL can not run from the SQL Commands dialog. As an example,
CREATE TABLE ttt ( id int NOT NULL, PRIMARY KEY ( id ) )
gives the error "ORA-00911: invalid character"..
I also tried to use SQL*Plus, but initially the only command I could make work was "EXIT". Not even HELP worked. Removing the "/nolog" option from the startup line did make SQL*Plus perform without any problems (so far!).
All in all my new meeting with Oracle (last visit was version 7.x) has been disappointing. I'm quite confident that Oracle basically is a nice and stable product, but what I've met with 10g simply is so sloppy I'd never recommend it to others.
CREATE TABLE ttt> (> id int NOT NULL,> PRIMARY KEY> (> id> )> )>
gives the error "ORA-00911: invalid character"..
It should not be be a surprise that the above throws an error as this is invalid syntax. Try the following instead:
CREATE TABLE ttt ( id NUMBER NOT NULL PRIMARY KEY );
I also tried to use SQL*Plus, but initially the only command I could> make work was "EXIT". Not even HELP worked. Removing the "/nolog"> option from the startup line did make SQL*Plus perform without any> problems (so far!).
If you have not installed help, then it will not work. You will receive the following:
SP2-0171: HELP not accessible.
All in all my new meeting with Oracle (last visit was version 7.x) has> been disappointing. I'm quite confident that Oracle basically is a nice> and stable product, but what I've met with 10g simply is so sloppy I'd> never recommend it to others.
From what I've seen above, the problem is not Oracle 10g, but rather the usage of it. ;)
Peter Koch Larsen 9 May 2006 01:49:33 [ permanent link ]
Brian Peasland skrev:
CREATE TABLE ttt> > (> > id int NOT NULL,> > PRIMARY KEY> > (> > id> > )> > )> >
gives the error "ORA-00911: invalid character"..>
It should not be be a surprise that the above throws an error as this is> invalid syntax. Try the following instead:>
CREATE TABLE ttt> (> id NUMBER NOT NULL PRIMARY KEY> );>
This is not true. All our DDL-statements are autogenerated following my original scheme. Also, Oracle accepts my original statement when i "fix" my SQL*PLUS command-line - a quite strong indication that you are mistaken (int is accepted, of course - it is ANSI syntax).
I also tried to use SQL*Plus, but initially the only command I could> > make work was "EXIT". Not even HELP worked. Removing the "/nolog"> > option from the startup line did make SQL*Plus perform without any> > problems (so far!).>
If you have not installed help, then it will not work. You will receive> the following:>
SP2-0171: HELP not accessible.
My original problem using SQL*PLUS came from using the shortcut installed via the default installation. If was my accidental usage of sql*plus from the command line that made me discover what the problem was. I also have help available - when not starting with the /nolog option.>
All in all my new meeting with Oracle (last visit was version 7.x) has> > been disappointing. I'm quite confident that Oracle basically is a nice> > and stable product, but what I've met with 10g simply is so sloppy I'd> > never recommend it to others.>
From what I've seen above, the problem is not Oracle 10g, but rather> the usage of it. ;)
As you might guess, I have another opinion of this matter. Let me add, that I have installed and used Microsoft SQL Server, Ingres and Sybase without any problems (well... not entirely true, but they certainly were minor compared to Oracle).>
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
![[Oracle 10g] Can't run SQL Scripts. Why?](http://qaix.com/i/logo_new.gif){kind=logo}
