BDN - Banner Developer Network

Here's a basic example of creating a SPRIDEN record using the gb_identification API. In actual production cases, you'd want to packaged this up; make the input parameters more dynamic; use common matching to prevent duplicate entries; etc etc.

Here is the quick and dirty example:

DECLARE
v_pidm spriden.spriden_pidm%TYPE := NULL;
v_rowid gb_common.internal_record_id_type;
v_id spriden.spriden_id%TYPE := 'GENERATED';
BEGIN
gb_identification.p_create(
p_id_inout=>v_id,
p_last_name=>'Moo Moo',
p_first_name=>'w00tz0r',
p_change_ind=>NULL,
p_entity_ind=>'P',
p_create_user=>'WHATEVER',
p_create_date=>sysdate,
p_pidm_inout=>v_pidm,
p_rowid_out=>v_rowid
);
END;
/