Creating New Location is Not Automatically Creating the Associated "GLOG" Refnum Entry For That Location (Doc ID 2094571.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

The trigger 'tg_location_refnum' is malformed.

Trigger is:
trigger tg_location_refnum
AFTER INSERT ON location
FOR EACH ROW
BEGIN
execute immediate glog_util.prepare_sql('INSERT INTO location_refnum ( location_gid,location_refnum_qual_gid,
location_refnum_value, domain_name )
VALUES (:1, ''GLOG'', :1, :2') using :new.location_gid, :new.domain_name;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;

Trigger is supposed to create a 'GLOG' refnum on any location inserted into the database. But is not doing so as it is incorrectly written.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.