I created a stored procedure called gt_names for my forms.
the stored procedure has 3 in parameters and
4 out parameters.
example create or replace gt_names(p_code1 in t.code1%type,
p_code2 in b.id1%type,
p_code3 in g.no%type,
p_name1 out t.name%type,
p_desc out t.desc%type,
p_lname out t.lname%type,
p_reg out t.regist%type)
My question is, how do I call this procedure with trigger in forms 6i.
Is it possible to give me a sample code?
The intent is to populate these fields if certain conditions are true.
thanks in advance
the stored procedure has 3 in parameters and
4 out parameters.
example create or replace gt_names(p_code1 in t.code1%type,
p_code2 in b.id1%type,
p_code3 in g.no%type,
p_name1 out t.name%type,
p_desc out t.desc%type,
p_lname out t.lname%type,
p_reg out t.regist%type)
My question is, how do I call this procedure with trigger in forms 6i.
Is it possible to give me a sample code?
The intent is to populate these fields if certain conditions are true.
thanks in advance