OraFAQ Forum: Forms » please help me

Home » Developer & Programmer » Forms » please help me

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

please help me [message #306164]

Thu, 13 March 2008 01:50

vinaya.v
Messages: 8
Registered: March 2008

Junior Member

hi all thanks for the help provided to me for my previous queries
now i hav some other doubts please help me
i hav created the folowing record group using query

select user_code,role_code from ssm_user_role_intersects
where user_code=:ssm_user_role_intersects.user_code

then in the new form instance trigger i hav written this code

declare
available_roles varchar2(30);
--rg_name VARCHAR2(40) := 'RECORD_GROUP76';
rg_id RecordGroup;
n NUMBER;
begin
rg_id := Create_Group_From_Query( 'RECORD_GROUP76', 'select user_code,role_code from ssm_user_role_intersects where user_code=:ssm_user_code_intersects.user_code');
n:=populate_group('RECORD_GROUP76');
populate_list('ssm_user_role_intersects.available_roles' ,'RECORD_GROUP76');
--abort_query;
end;

my task is to assign this record group to a list item and to populate the values there during run time

this code doesnt throw me errors
but the values are not populated.

thanks

Report message to a moderator