Re: populate record group error

I think it's wrong.
Then a group should execute query like this : SELECT role.name, screen.name FROM role, screen WHERE role.name = v_role_name
so what is it ? sql return an error , what is v_role_name ? The select for this group should be like this :
'SELECT role.name, screen.name FROM role, screen WHERE role.name ='|| v_role_name or better
'SELECT role.name, screen.name FROM role, screen WHERE role.name ='''|| v_role_name||''''
You have to pass a VALUE of v_role_name not just a string 'v_role_name'; Maciej Myrcha
U¿ytkownik <pberetta_at_my-deja.com> napisa³ w wiadomo¶ci news:8a2mbi$dfg$1_at_nnrp1.deja.com...
> Diane,
> Just a guess, but if 'formCategory' is a quoted string in your
> command line SQL*Plus, then this might solve your problem:
> Declare
> group_id RecordGroup;
> query_ok NUMBER;
> v_role_name VARCHAR2(11) := 'formCategory';
> BEGIN
> group_id := Create_Group_From_Query('common_group',
> 'SELECT role.name, screen.name
> FROM role, screen
> WHERE role.name = v_role_name',
> GLOBAL_SCOPE);
> query_ok := Populate_Group(group_id);
> IF query_ok <> 0 THEN
> RAISE FORM_TRIGGER_FAILURE;
> END IF;
> END;
>
> Regards,
> Paul
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 08 2000 - 11:28:41 CET