PL/SQL (MOSC)

MOSC Banner

How to get Check Number in After Insert Trigger on ap_checks_all

edited Sep 8, 2021 5:21AM in PL/SQL (MOSC) 1 commentAnswered ✓

I'm using following piece of code to get the check_number in a trigger, but Im always getting -1 as the check-number

create or replace TRIGGER xx_ap_checks_trg AFTER

  INSERT ON ap_checks_all

  FOR EACH ROW

DECLARE

  lc_check_num number;

BEGIN

  lc_check_num := :new.CHECK_NUMBER;

END;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center