Hi all


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 ").

Can anyone help me to get on my feet again?

Kind regards
Peter Koch Larsen

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.

HTH,
Brian

--
================================================== =================

Brian Peasland
oracle_dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

peter.koch.larsen (AT) gmail (DOT) com wrote:
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?

gazzag wrote:
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.

Kind regards
Peter

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
);


If you have not installed help, then it will not work. You will receive
the following:

SP2-0171: HELP not accessible.

From what I've seen above, the problem is not Oracle 10g, but rather
the usage of it.

Cheers,
Brian


--
================================================== =================

Brian Peasland
oracle_dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Brian Peasland skrev:

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).

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.
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).