OraFAQ Forum: Forms » identifier 'SET_CALENDAR' must be declared

Home » Developer & Programmer » Forms » identifier 'SET_CALENDAR' must be declared

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

identifier 'SET_CALENDAR' must be declared [message #259300]

Tue, 14 August 2007 23:47

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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #259312 is a reply to message #259300]

Wed, 15 August 2007 00:19

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #259326 is a reply to message #259300]

Wed, 15 August 2007 01:13

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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #259337 is a reply to message #259326]

Wed, 15 August 2007 01:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #259343 is a reply to message #259300]

Wed, 15 August 2007 02:33

a5hhk
Messages: 17
Registered: August 2007

Junior Member

how can i upagrade my libraries and my objects?

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #259345 is a reply to message #259343]

Wed, 15 August 2007 02:36

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

The same way you upgrade your forms.

David

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #259346 is a reply to message #259300]

Wed, 15 August 2007 02:41

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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #259347 is a reply to message #259346]

Wed, 15 August 2007 02:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #259351 is a reply to message #259300]

Wed, 15 August 2007 03:14

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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #260273 is a reply to message #259300]

Fri, 17 August 2007 23:11

a5hhk
Messages: 17
Registered: August 2007

Junior Member

please any body can help me in this issue

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #260760 is a reply to message #260273]

Mon, 20 August 2007 20:13

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #260796 is a reply to message #259300]

Mon, 20 August 2007 23:28

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

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #260825 is a reply to message #260796]

Tue, 21 August 2007 01:30

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay. Now post the code that exists in that trigger. Please.

David

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #260959 is a reply to message #259300]

Tue, 21 August 2007 06:30

a5hhk
Messages: 17
Registered: August 2007

Junior Member

the code is only this statement
SET_CALENDAR;

Report message to a moderator

Re: identifier 'SET_CALENDAR' must be declared [message #261103 is a reply to message #260959]

Tue, 21 August 2007 19:03

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Are there any libraries attached to this form? If so, what are they called.
Does one of these libraries contain an entry for 'set_calendar'?
Is that library in your directory?
Is that directory in the various 'paths' associated with your forms?
Do your other forms compile?
Is the name of your directory in the 'start in' parameter of the shortcut through which you start the Forms Builder?

David

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 01:28:07 CST 2025