PLSql: Error when updating a table with a trigger conflict
0
I need to update the status of a value in a table but the table has an associated trigger with a not null condition, it is throwing an error ORA-01400 error.
UPDATE ***** SET IND_VALID='0' WHERE ***** IN ('330534');
This is the trigger code
create or replace
TRIGGER "*******"."TIDUA_ECHANTFCE"
AFTER
INSERT OR DELETE OR UPDATE
ON MASTERCA.ECHANTFCE REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
declare
seq_id integer;
change_reason varchar2(4000);
login varchar2(250);
Version varchar2(80);
begin
Version := 'AUDIT_TRAIL V1.0 / SPEC : xxxxxx v xx';
change_reason := system.AUDTRAIL_CHGREASON.get_change_reason();
login := system.connectionpool.get_user_login();
select seq_audit_trail.nextval into seq_id from dual;
if UPDATING then
insert into audtrailrow (audit_trail_row_id,table_name, data_row_id, change_type, user_login,
change_dt, change_reason_value)
values (seq_id, 'ECHANTFCE', :new.ID_ECHANT_FCE, 'U', login, sysdate, change_reason);
oracle plsql
asked Nov 23 '18 at 6:59
Marksvmax90Marksvmax90
11
add a comment |
0
I need to update the status of a value in a table but the table has an associated trigger with a not null condition, it is throwing an error ORA-01400 error.
UPDATE ***** SET IND_VALID='0' WHERE ***** IN ('330534');
This is the trigger code
create or replace
TRIGGER "*******"."TIDUA_ECHANTFCE"
AFTER
INSERT OR DELETE OR UPDATE
ON MASTERCA.ECHANTFCE REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
declare
seq_id integer;
change_reason varchar2(4000);
login varchar2(250);
Version varchar2(80);
begin
Version := 'AUDIT_TRAIL V1.0 / SPEC : xxxxxx v xx';
change_reason := system.AUDTRAIL_CHGREASON.get_change_reason();
login := system.connectionpool.get_user_login();
select seq_audit_trail.nextval into seq_id from dual;
if UPDATING then
insert into audtrailrow (audit_trail_row_id,table_name, data_row_id, change_type, user_login,
change_dt, change_reason_value)
values (seq_id, 'ECHANTFCE', :new.ID_ECHANT_FCE, 'U', login, sysdate, change_reason);
oracle plsql
asked Nov 23 '18 at 6:59
Marksvmax90Marksvmax90
11
It seems the error is thrown by the trigger. You need to post the trigger code if you hope for us to help you.
– APC
Nov 23 '18 at 7:10
1
ORA-01400: cannot insert null into (string) is a specific error to the null value in Oracle. According to Oracle, a null value can appear in columns of any datatype as long as it is not set to the value “not null” or is restricted by primary key integrity constraints. can you share all the code !!!
– Steve Ruben
Nov 23 '18 at 7:36
add a comment |
0
0
0
I need to update the status of a value in a table but the table has an associated trigger with a not null condition, it is throwing an error ORA-01400 error.
UPDATE ***** SET IND_VALID='0' WHERE ***** IN ('330534');
This is the trigger code
create or replace
TRIGGER "*******"."TIDUA_ECHANTFCE"
AFTER
INSERT OR DELETE OR UPDATE
ON MASTERCA.ECHANTFCE REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
declare
seq_id integer;
change_reason varchar2(4000);
login varchar2(250);
Version varchar2(80);
begin
Version := 'AUDIT_TRAIL V1.0 / SPEC : xxxxxx v xx';
change_reason := system.AUDTRAIL_CHGREASON.get_change_reason();
login := system.connectionpool.get_user_login();
select seq_audit_trail.nextval into seq_id from dual;
if UPDATING then
insert into audtrailrow (audit_trail_row_id,table_name, data_row_id, change_type, user_login,
change_dt, change_reason_value)
values (seq_id, 'ECHANTFCE', :new.ID_ECHANT_FCE, 'U', login, sysdate, change_reason);
oracle plsql
asked Nov 23 '18 at 6:59
Marksvmax90Marksvmax90
11
I need to update the status of a value in a table but the table has an associated trigger with a not null condition, it is throwing an error ORA-01400 error.
UPDATE ***** SET IND_VALID='0' WHERE ***** IN ('330534');
This is the trigger code
create or replace
TRIGGER "*******"."TIDUA_ECHANTFCE"
AFTER
INSERT OR DELETE OR UPDATE
ON MASTERCA.ECHANTFCE REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
declare
seq_id integer;
change_reason varchar2(4000);
login varchar2(250);
Version varchar2(80);
begin
Version := 'AUDIT_TRAIL V1.0 / SPEC : xxxxxx v xx';
change_reason := system.AUDTRAIL_CHGREASON.get_change_reason();
login := system.connectionpool.get_user_login();
select seq_audit_trail.nextval into seq_id from dual;
if UPDATING then
insert into audtrailrow (audit_trail_row_id,table_name, data_row_id, change_type, user_login,
change_dt, change_reason_value)
values (seq_id, 'ECHANTFCE', :new.ID_ECHANT_FCE, 'U', login, sysdate, change_reason);
oracle plsql
oracle plsql
asked Nov 23 '18 at 6:59
Marksvmax90Marksvmax90
11
asked Nov 23 '18 at 6:59
Marksvmax90Marksvmax90
11
edited Nov 26 '18 at 3:33
Marksvmax90
asked Nov 23 '18 at 6:59
Marksvmax90Marksvmax90
11
asked Nov 23 '18 at 6:59
Marksvmax90Marksvmax90
11
asked Nov 23 '18 at 6:59
Marksvmax90Marksvmax90
11
11
It seems the error is thrown by the trigger. You need to post the trigger code if you hope for us to help you.
– APC
Nov 23 '18 at 7:10
1
ORA-01400: cannot insert null into (string) is a specific error to the null value in Oracle. According to Oracle, a null value can appear in columns of any datatype as long as it is not set to the value “not null” or is restricted by primary key integrity constraints. can you share all the code !!!
– Steve Ruben
Nov 23 '18 at 7:36
add a comment |
It seems the error is thrown by the trigger. You need to post the trigger code if you hope for us to help you.
– APC
Nov 23 '18 at 7:10
1
ORA-01400: cannot insert null into (string) is a specific error to the null value in Oracle. According to Oracle, a null value can appear in columns of any datatype as long as it is not set to the value “not null” or is restricted by primary key integrity constraints. can you share all the code !!!
– Steve Ruben
Nov 23 '18 at 7:36
It seems the error is thrown by the trigger. You need to post the trigger code if you hope for us to help you.
– APC
Nov 23 '18 at 7:10
It seems the error is thrown by the trigger. You need to post the trigger code if you hope for us to help you.
– APC
Nov 23 '18 at 7:10
1
1
ORA-01400: cannot insert null into (string) is a specific error to the null value in Oracle. According to Oracle, a null value can appear in columns of any datatype as long as it is not set to the value “not null” or is restricted by primary key integrity constraints. can you share all the code !!!
– Steve Ruben
Nov 23 '18 at 7:36
ORA-01400: cannot insert null into (string) is a specific error to the null value in Oracle. According to Oracle, a null value can appear in columns of any datatype as long as it is not set to the value “not null” or is restricted by primary key integrity constraints. can you share all the code !!!
– Steve Ruben
Nov 23 '18 at 7:36
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53441979%2fplsql-error-when-updating-a-table-with-a-trigger-conflict%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53441979%2fplsql-error-when-updating-a-table-with-a-trigger-conflict%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It seems the error is thrown by the trigger. You need to post the trigger code if you hope for us to help you.
– APC
Nov 23 '18 at 7:10
1
ORA-01400: cannot insert null into (string) is a specific error to the null value in Oracle. According to Oracle, a null value can appear in columns of any datatype as long as it is not set to the value “not null” or is restricted by primary key integrity constraints. can you share all the code !!!
– Steve Ruben
Nov 23 '18 at 7:36