I was creating a calendar using the follwing steps:
1. Copy or make the Calendar Object
Group a subclass.
2. Attach the PL/SQL library
3. Create a Key-Listval trigger.
4. Call Date_LOV.Get_Date.
I'm a begginer and I need to know how to do the steps 3 & 4
when I write the following code in the trigger key_listval of the item that i want to use date_lov window the following error rise:
IDENTIFIER 'DATE_LOV.GET_DATE' MUST BE DECLARED
Also I get an error In the procedure body DATE_CHOOSEN
IDENTIFIER 'DATE_LOV.CURRENT_LOV_DATE' MUST BE DECLARED
So I may be did somthing wrong or missed some step !
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.