All Questions
Tagged with oracle-apex triggers
72 questions
-2
votes
2
answers
173
views
Oracle APEX error on insert row - ORA-00001: exclusive restriction (ASCHEMAXXXXX.Table_name_PK) violated
Why am I getting this error when trying to insert a new row in the APEX app?
ORA-00001: exclusive restriction (ASCHEMAXXXXX.Table_name_PK) violated
There is a dynamic action on page load to get the ...
0
votes
1
answer
132
views
solve err in before insert trigger on pl/sql
I create table b
create table b(
id number(3),
name varchar2(5),
birth_day date
);
& I create trigger p
create or replace trigger p
before insert on b
for each row
declare
g number;
begin
...
0
votes
1
answer
94
views
how to solve the error 'ORA-04091: table WKSP_APEXHENRY.TEST1 is mutating, trigger/function may not see it' on Oracle APEX
I create a trigger with oracle apex. And I created an App with oracle apex. The code is as follows:
CREATE TABLE test1
(
test1data1 INT NOT NULL,
test1data2 INT NOT NULL,
test1key VARCHAR(20) ...
0
votes
1
answer
50
views
How can I write the difference between sysdate - due-date on trigger
CREATE TABLE penalty(
member_id number(11) NOT NULL,
punishment_cost number(3),
punishment_rate number(3),
total_cost number(11)
);
CREATE TABLE member(
member_id number(11) NOT ...
- 1
0
votes
0
answers
43
views
How can I make reservation control?
CREATE TABLE member(
member_id number(11) NOT NULL PRIMARY KEY,
member_name varchar2(255) NOT NULL,
member_surname varchar2(255) NOT NULL,
gender varchar2(30) NOT NULL,
birthdate ...
- 1
0
votes
1
answer
354
views
PLS-00049: bad bind variable
CREATE TABLE member(
member_id number(11) NOT NULL PRIMARY KEY,
member_name varchar2(255) NOT NULL,
member_surname varchar2(255) NOT NULL,
gender varchar2(30) NOT NULL,
birthdate ...
- 1
2
votes
2
answers
461
views
Function to detect Columns getting Updated For Oracle Apex
I wrote a function to detect which columns are getting updated for a table.
This Table is present in Oracle Apex.
I use this function to send mail for Update performed through APEX UI on it.
Trigger ...
- 73
1
vote
1
answer
108
views
Update column value of a table when the value of another table changes
I have 3 tables (Inventory, OrderMaster, OrderDetail). In the table Inventory I have ID_PRODUCT and quantity_inventory columns. In the table OrderMaster I have ID_ORDER and ID_STATE_OF_ORDER (all rows ...
- 15
0
votes
1
answer
21
views
I'm facing error in trigger(Encountered the symbol "IF" when expecting one of the following: ; <an identifier> <a double-quoted delimited-identifier>)
--I am a beginner in oracle and facing an error while executing a trigger and need your help
CREATE OR REPLACE TRIGGER hamza
AFTER INSERT OR UPDATE ON RAW_MATERAIL
FOR EACH ROW
DECLARE
VAR number;...
- 1
1
vote
2
answers
622
views
Oracle - Trigger to perform multiple operations: Delete rows, TRIM and Replace special characters
I have data as below in csv format and uploading this data into table:
TABLE NAME: MYDATA
+----+-------+-------+---------+
| ID | NAME | STATE | CODE |
+----+-------+-------+---------+
| 1 | P&...
- 449
0
votes
1
answer
179
views
How to create a trigger which will auto create sequence ID
I have been trying to implement the logic. But as only basic knowledge on SQL.
I have a below following table
create upload
(
fileblob blob,
mimetype varchar2(4000 char),
filename varchar2(4000 ...
- 205
0
votes
1
answer
31
views
Update Column from Table With Data Updated in another table
I have two tables
CREATE TABLE "LOCKER_AUDIT"
( "ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 ...
- 47
0
votes
1
answer
281
views
trigger to set date automatic after update
Some background info: i have a table named defects which has column named status_id and another column named date_closed ,i want to set date_closed after status_id has been updated
i already try to do ...
- 39
1
vote
1
answer
613
views
Execute immediate 'alter trigger ... disable' with pragma autonomous_transaction in a trigger crashes Oracle Apex
I'm trying to denormalize these two tables with a Pre-Join denormalization and have to add all the needed triggers.
The tables look basically like this:
CLIENTS
Client_ID CHAR(13),
Client_Name ...
0
votes
0
answers
467
views
Why does the trigger get executed multiple times when updating the table in interactive grid?
I created a trigger to send an email notification if a table is updated, now the table is actually an interactive grid with an "Update" button which actually updates through PL/SQL procedure ...
- 1