For oracle table creation since the increase, the code is as follows:
The CREATE SEQUENCE SRSC_USER_SEQUENCE
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;

CREATE the TRIGGER SRSC_USER_TRIGGER BEFORE
Insert ON SRSC_USER FOR EACH ROW
The begin
The select SRSC_USER_SEQUENCE. Nextval into: New Server_ID from dual;
end;

But appear (Err) ORA - 24344: success, but a compiler error
What reason be excuse me??????? Pray god help???????

CodePudding user response:

This is not the show err output?

CodePudding user response:

Seems to be problems reference object in the code, the code itself has no problems,

CodePudding user response:

LZ, you of the ORACLE version, table statements, and error messages are posted, you it's weird,

CodePudding user response:

Using ORACLE10g and navicat for oracle, the software to create table create a trigger



In the table attribute only have these four


And create table on the other, use this code, have succeeded without problems, the table appears the question, I don't know why??

CodePudding user response:

reference 4 floor q172023650 response:

is ORACLE10g and navicat for oracle, the software to create table create a trigger



In the table attribute only have these four


And create table on the other, use this code, have succeeded without problems, the table appears the question, I don't know why??

It's strange that you the length of the number is 0, you specify the length of the number will try table reconstruction

CodePudding user response:

Length is changed, but still the original problems

What's the matter???????

CodePudding user response:

Finally done is really a pit dad is a waste of time!

The properties of each column in table names into capital is that the

CodePudding user response:

Seems to be field names are case sensitive, cause: New. Server_ID couldn't find the corresponding fields

CodePudding user response:

Should be the problem of case, pay attention to later.

CodePudding user response:

The column name is capitalized, learning,,,, thanks,

CodePudding user response:

This problem I also met a few days ago, to control the binding values, how to don't show, later changed to uppercase, I brush, ok,

CodePudding user response:

My column names are capitalized and this mistake how to return a responsibility??

CodePudding user response:

Me too, column caps, why still don't compile by

CodePudding user response:

Two years ago the post

CodePudding user response:

Column names are capitalized why can appear such errors, strives for the great god answer

CodePudding user response:

with upstairs, column names are capitalized, or the mistakes, how to do