All Questions
30 questions
1
vote
1
answer
197
views
Oracle: Insert only unique records into custom record in compound trigger
I am having a compound trigger in the following format. I need to ensure that my custom declaration ints_rows takes only "unique rows". Meaning if the ints_rows already has a record similar ...
- 35.6k
0
votes
0
answers
48
views
Create SQL Developer procedure?
I have following database
Customer (customerNO, customerName, address, city, category, custBalance)
Product (productNO, label, price, QStock)
CustomerOrder (orderNO, orderDate, #customerNO)
...
1
vote
3
answers
468
views
PL/SQL Trigger doesn't work on brand new inserted data
I've created a trigger to check if someone updated a salary or inserted a new employee on the employees table using the procedure for checking, below is my code for my procedure and my trigger:
CREATE ...
- 23
0
votes
1
answer
530
views
How to call procedure using triggers
Table:
create table department(deptno number, deptname varchar2(50), deptloc varchar2(50));
insert into department values(1,'A','X');
insert into department values(2,'B','Y');
insert into department ...
- 57
1
vote
1
answer
165
views
Trigger if-else statement error not being raised
I have created a procedure and a trigger and my intention is to pay the fares that the amount of fares entered must be more than or equals to the exact amount within the Payment Table
As from the ...
- 103
2
votes
1
answer
61
views
Trigger could not be executed due to table mutating
I want to know what is the problem for this issue whereby it kept on showing me this error when I execute my stored procedure. My goal is to before updating data into my table using my stored ...
- 143
2
votes
1
answer
90
views
Continue with stored procedure when trigger not finding any errors
I'm really new to Oracle, I want to know how to continue to run my procedure if my trigger not detecting any errors.
I just want to continue to run my procedure if those two exception within trigger ...
- 143
0
votes
1
answer
39
views
If I can do all I need in a procedure why would I use a trigger at all? [closed]
I have a general question about why I'd need a trigger if I can do the checks and such and validations in a procedure.?
- 1,469
1
vote
1
answer
915
views
Oracle 12 PL/SQL retrieving a stored procedure name within a trigger
I have a situation by using a trigger I want to record the name of the stored procedure that initiated a stack of stored procedure calls that ultimately perform an INSERT into the table that the ...
- 3,484
0
votes
1
answer
100
views
ORACLE SQL TRIGGER OR STORED PROCEDURE ON TWO DIFFERENT TABLES
I have two tables. I want to create a trigger on this two tables. Columns in tables are like below.
Table_A
CL_ID, TIMESTAMP_A, OUT_ID, STATUS ETC.
Table_B
OUT_ID, TIMESTAMP_B, ETC.
Data insert ...
- 35
0
votes
2
answers
410
views
simple trigger/procedure problem for oracle apex sql
im trying to run this audit trail trigger in oracle apex sql but i keep getting the same error and i dont know what im doing wrong.
also i need to do this same trigger to every table in my database... ...
0
votes
0
answers
46
views
How to use Trigger on Multiple table?
I have multiple tables EMP_001,EMP_002,EMP_003,EMP_004 and so on.. All the tables have common columns. Is there any way to make a common trigger for the tables.
I wanted to log the deleted value of ...
0
votes
1
answer
1k
views
creating a trigger on a dynamically added table inside a procedure
I'am creating dynamic tables from java. What I want is that I want to create a trigger on every new table added which will just use the sequence to populate the primary key(serial_no) which is common ...
- 31
0
votes
2
answers
518
views
Execute a stored procedure through a trigger right after a user was created on the database
I would like to write a procedure can grant role permissions to a new created user.
My thoughts were that I first create a procedure like this:
CREATE OR REPLACE PROCEDURE P_CREATE_USER
BEGIN
...
user7721536
1
vote
2
answers
3k
views
A better approach than Oracle trigger
We're supposed to update some columns in a table 'tab1' with some values(which can be picked up from a different table 'tab2'). Now 'tab1' is getting new records inserted almost every few seconds(from ...
- 1,044