Re: Help....Strange Error...

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 17 Jul 2005 07:46:19 -0400
Message-ID: <mOKdnakeZJCT2EffRVn-hg_at_comcast.com>


"Rashrashetta" <rasha_cs_99_at_hotmail.com> wrote in message news:6c999f04.0507170025.53bbffd_at_posting.google.com...
> Hai all...
>
> I am stuck with this piece of code...which I wrote inside a
> trigger....but it shows error for set_lov_property function...Can
> anyone help me please?!
>
> *************************Here is the
> code**************************************
>
> declare
> time_group recordgroup;
> query_result NUMBER;
> lovid LOV;
>
> begin
>
> time_group := find_group('appointment.LOV_APPOINTMENT_SPECIFIED_DAY');
> lov_id := Find_LOV('LOV_APPOINTMENT_SPECIFIED_DAY');
>
> if :APP_DATE is not null then
>
> time_group := Create_Group_From_Query('time_group','select
> available_times from apptimes where available_times not in
> (select to_char(APPDATE,''HH:MI:SS'') from appointment WHERE
> TRUNC(APPDATE)= :APP_DATE)');
>
> query_result :=populate_group('time_group');
>
> ***Set_LOV_Property(lovid, GROUP_NAME ,time_group);
>
> else
> Set_Item_Property('CONTROLAPPOINTMENT.APP_DATE',LOV_NAME
> ,'APPOINTMENT_DAY');
>
> end if;
> end;
>
> Thanks,
> Rashrashetta

what is the error?
what is the expected result?
what is the trigger?
what is the tool?
what is the tool version?
what is the db version?
what is the OS?
what is the OS version?

++ mcs Received on Sun Jul 17 2005 - 13:46:19 CEST

Original text of this message