CODEWITHSUNDEEP
sqloracle-databaseweb-applicationsstored-procedurestriggers
Malavos
Malavos

Reputation: 427

Oracle triggers and stored procedures

I need to make for my webApp a trigger to execute a stored procedure on Oracle. But i'm very new to Oracle and I'm still getting the hang of it. I can make a simple Trigger with a sequence to auto-increment a value from a table, but that's it.

Is there any good tutorials and examples available on this specific subject? I tried searching here, but i have only found a very generic question: How can i learn Stored Procedure and Trigger?. But i can be more specific: I need this trigger to run a stored procedure that generates a new code for my user, adding data to this code. The procedure is done, i just don't know how to use it in a trigger, pass the parameters, and how to insert/update values from the oracle trigger itself.

Help will be much appreciated.

Upvotes: 0

Views: 282

Answers (1)

user330315
user330315

Reputation:

Assuming your function to generate the code is named f_generate_code() and your table is named foobar and the column that should be populated is name code you'd do it like this:

create or replace trigger trg_update_code
  before insert or update on foobar
  for each row
begin
  :new.code := f_generate_code();
end;
/

Upvotes: 2

Related Questions