Compile errors implementing calendar demo into my form.

Posted on 2004-08-20
Last Modified: 2012-06-21
I am trying to implement the oracle calendar demo into my form but I receive the following errors for Program Units "DATE_CHOOSEN* (Procedure Body),

Error 201 at line 3, column 17
 identifier 'DATE_LOVE.CURRENT_LOV_DATE' must be declared
Error 0 at line 3, column 4
 Statement ignored
Error 201 at line 4, column 12
 identifier 'DATE_LOV.DATE_LOV_RETURN_ITEM' must be declared
Error 0 at line 4, column 4
 Statement ignored
Error 201 at line 5, column 7
 identifier 'DATE_LOV.LOV_AUTO_SKIP' must be declared
Error 0 at line 5, column 4
 Statement ignored

I have followed all oracle help documentation and related posts about implementing the calendar form but I'm stuck on these compile errors. I know I have got to be missing something simple. Please point me towards the light.


Question by:Ricotti
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
LVL 35

Expert Comment

by:Mark Geerlings
ID: 11852811
Did you copy both the program unit (DATE_CHOOSEN) and the LOV (DATE_LOV) into your Form?  If so, it should compile without error.

Author Comment

ID: 11853307

Here is some more detailed steps on what I have done,

1. Create a new MODULE in Forms Builder (well, I used a copy of my form I am trying to add calendar to)

2. Then open the stndrd20.olb file (this .olb file is located    in the ORACLE_HOME/TOOLS/DEVDEMXX/Forms FOLDER)

3. You will see 'STANDARDS' appear under 'Object Libraries' in the Object     Navigator

4. Double click on the book-like icon next to 'STANDARDS'

5. Expand the object library window that appears

6. Click on the 'COMPONENTS' tab

7. Look for the 'CALENDAR' object library  

8. Drag-n-drop the 'CALENDAR' object into your new form (I subclassed it)

9. Notice all the new items are now in your form marked with a red arrow*    *The red arrow means that the items are subclassed.

10. Attach the PL/SQL library CALENDAR.PLL    (this .pll file is also located in the ORACLE_HOME/TOOLS/DEVDEMXX/Forms     FOLDER) ( I went to file, open, and opened calendar.pll file. I then clicked on Attached Libraries under the Calendar PL/SQL Libraries section and went to browse and selected calendar.pll file and left File System radio button filled in. When I click attached it asks if I want to remove the path, and I click YES)

11. In Forms, Create a new block on a new canvas (well, I used a copy of my form I am trying to add the calendar to)

12. Create a Key-Listval trigger on the date item for which you  would like to use the Date LOV Window. Add the below code to display the calendar using the Date_LOV package.  ( I created a date item in my form datablock where I want to use the calendar. I then created a trigger under this item for Key-Listval and pasted the code below into the trigger.)

date_lov.get_date(sysdate,         -- initial date                
'emp.hiredate',  -- return block.item                  
240,             -- window x position                  
60,              -- window y position                  
'Start Date',    -- window title                  
'OK',            -- ok button label                  
'Cancel',        -- cancel button label                  
TRUE,            -- highlight weekend days                  
FALSE,           -- autoconfirm selection                  
FALSE);          -- autoskip after selection

The calendar program unit and Lovs are in my form after doing the above steps.

I hope this information helps more on solving this problem. I have gone through these steps from scratch many times and I end up stuck at these compile errors everytime. I can't get past this point, I am missing something.


LVL 35

Expert Comment

by:Mark Geerlings
ID: 11853402
That looks correct.  I didn't test all of those steps now, but we had done about the same thing here some time ago when we started building our custom Forms application in Forms6.  We still have some Forms that have this program unit and LOV in them and they compile fine when we make other small changes.

For a test, you could try copying rather than sub-classing the objects and see if the Form compiles that way.  The error messages make it look like the Forms compiler does not see the DATE_LOV as being in the Form.
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.


Author Comment

ID: 11853537
Also to add on this, I get the same compile errors when trying to compile the calendar.fmb.

I will try the copy instead of subclass though real quick and post results asap.

The DATE_LOV is not actually supposed to appear under the LOVs section on the Object Navigator is it?  On the calendar.fmb and my own form the DATE_LOV is under Program Units under Calendar in the P:/SQL Libraries section of the Object Navigator.

Hope this helps.



Author Comment

ID: 11853742
I started from scratch again and tryed the copy instead of the subclass and still results with same compilers. Its like you said Markgeer, it is acting like it cannot see DATE_LOV. Hmm.. And its odd too that my calendar.fmb from oracle (not messed with at all) has same errors when compiled. Do I have some bad files maybe?



Author Comment

ID: 11853776
First sentence on last post is supposed to end with "compile errors" not "compilers". =)  


LVL 35

Accepted Solution

Mark Geerlings earned 350 total points
ID: 11853918
You are correct on DATE_LOV.  I just checked one of our Forms that uses it.  That is a package in the calendar.pll file, it is not an LOV that needs to be copied or sub-classed in to the Form.
So, either your calendar.pll file is bad, or for some reason the Forms compiler does not see the contents of that pll file as being available when it tries to compile the Form.
Is that pll file in the same directory as your *.fmb?  Or, is it in a directory that is included in your FORMSxx_PATH variable?  We just put all of our *.fmb, *.pll and *.mmb files in one directory, and set that as the working directory for Forms Designer.  That way we don't have to worry about the Formsxx_path value, and our forms always compile without complaining about pll library problems.

Author Comment

ID: 11854147
Markgeer! I put the calendar.fmb, calendar.pll, and stndrd20.olb in its own directory and I am now successfully able to compile the form!! These files were located in the same directory before but along with many other oracle forms and objects etc from default. So there must of been some conflict with another file. =)

Thanks your good tips Markgeer!


Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Creation date for a PDB 5 86
Query - Duplicate dates with different activities counts 10 58
return value based on substr 10 73
How to combine two oracle database together 9 76
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question