Home » Developer & Programmer » Forms » identifier 'SET_CALENDAR' must be declared
identifier 'SET_CALENDAR' must be declared [message #259300] Tue, 14 August 2007 23:47 Go to next message
a5hhk
Messages: 17
Registered: August 2007
Junior Member
Hi
I want to compile my template form
but after i compile it , it come only with this error
identifier 'SET_CALENDAR' must be declared
can any body help me to solve this problem.

THANK YOU
Re: identifier 'SET_CALENDAR' must be declared [message #259312 is a reply to message #259300] Wed, 15 August 2007 00:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What version of Forms are you using? Open the form in the Forms Builder and use the 'find' facility to search for 'SET_CALENDAR'.

David
Re: identifier 'SET_CALENDAR' must be declared [message #259326 is a reply to message #259300] Wed, 15 August 2007 01:13 Go to previous messageGo to next message
a5hhk
Messages: 17
Registered: August 2007
Junior Member
thank u david for replaying
i use form 6i
and i want to put it in the template form in apps
,this problem came after we make upgrada of our oracle 11i

thanks
Re: identifier 'SET_CALENDAR' must be declared [message #259337 is a reply to message #259326] Wed, 15 August 2007 01:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I suggest upgrading your PL/SQL libraries, object libraries, and menues, and then upgrading your forms. Verify that you have done this and that the attached libraries have been done WITHOUT using the directory names.

Open the form and look at the attachment properties.

David
Re: identifier 'SET_CALENDAR' must be declared [message #259343 is a reply to message #259300] Wed, 15 August 2007 02:33 Go to previous messageGo to next message
a5hhk
Messages: 17
Registered: August 2007
Junior Member
how can i upagrade my libraries and my objects?
Re: identifier 'SET_CALENDAR' must be declared [message #259345 is a reply to message #259343] Wed, 15 August 2007 02:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The same way you upgrade your forms.

David
Re: identifier 'SET_CALENDAR' must be declared [message #259346 is a reply to message #259300] Wed, 15 August 2007 02:41 Go to previous messageGo to next message
a5hhk
Messages: 17
Registered: August 2007
Junior Member
Sorry David
I did not upgrading my form
our DBA he is the one upgrade the version of our oracle.

Can I get upgradede libraries from the internet.

Thanks
Re: identifier 'SET_CALENDAR' must be declared [message #259347 is a reply to message #259346] Wed, 15 August 2007 02:47 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Okay, you have upgraded your database to 11g (not 11i) but you haven't changed your forms. Right??

Open the form that is failing and find out where the 'SET_CALENDAR' is defined. Is it in the Form's own procedures, in a library, or defined in the database.

If your application was working, why do you want to add anything to the template?

David
Re: identifier 'SET_CALENDAR' must be declared [message #259351 is a reply to message #259300] Wed, 15 August 2007 03:14 Go to previous messageGo to next message
a5hhk
Messages: 17
Registered: August 2007
Junior Member
Mr.David
NOT RIGHT,NO ,we upgrade our oracle to another version of oracle 11i.

the problem is when i compile the form
this error coming.
it is built-in and i did not added to the form.

AND 'SET_CALENDAR' LOCATED IN THE TRIGGER IN CALENDATE OBJECT

THANKS
Re: identifier 'SET_CALENDAR' must be declared [message #260273 is a reply to message #259300] Fri, 17 August 2007 23:11 Go to previous messageGo to next message
a5hhk
Messages: 17
Registered: August 2007
Junior Member
please any body can help me in this issue
Re: identifier 'SET_CALENDAR' must be declared [message #260760 is a reply to message #260273] Mon, 20 August 2007 20:13 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
With what part of
Quote:
Open the form that is failing and find out where the 'SET_CALENDAR' is defined. Is it in the Form's own procedures, in a library, or defined in the database.
are you having a problem?

David
Re: identifier 'SET_CALENDAR' must be declared [message #260796 is a reply to message #259300] Mon, 20 August 2007 23:28 Go to previous messageGo to next message
a5hhk
Messages: 17
Registered: August 2007
Junior Member
it define in trigger
(when-new-block-instance)
on calender object on data block level

thank you
Re: identifier 'SET_CALENDAR' must be declared [message #260825 is a reply to message #260796] Tue, 21 August 2007 01:30 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Okay. Now post the code that exists in that trigger. Please.

David
Re: identifier 'SET_CALENDAR' must be declared [message #260959 is a reply to message #259300] Tue, 21 August 2007 06:30 Go to previous messageGo to next message
a5hhk
Messages: 17
Registered: August 2007
Junior Member
the code is only this statement
SET_CALENDAR;
Re: identifier 'SET_CALENDAR' must be declared [message #261103 is a reply to message #260959] Tue, 21 August 2007 19:03 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
  1. Are there any libraries attached to this form? If so, what are they called.
  2. Does one of these libraries contain an entry for 'set_calendar'?
  3. Is that library in your directory?
  4. Is that directory in the various 'paths' associated with your forms?
  5. Do your other forms compile?
  6. Is the name of your directory in the 'start in' parameter of the shortcut through which you start the Forms Builder?
David
Previous Topic: MS calender should be opened in Current month and Date But it is opened in Previous Month and I want
Next Topic: I can not find the document...
Goto Forum:
  


Current Time: Sat Dec 03 16:12:46 CST 2016

Total time taken to generate the page: 0.04538 seconds