OraFAQ Forum: Forms » Problem with Create Trigger

Home » Developer & Programmer » Forms » Problem with Create Trigger (Forms 6i)

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

Problem with Create Trigger [message #288131]

Sat, 15 December 2007 00:16

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

Hi
I have a problem with form builder 6i .
when I want create a new Trigger the folowing Error is occured :

Quote:

A Program Unit Named P0_24_138600_00_00 already exist .
continue creation ?

when i select "YES" One Of exist Trigger is delete randomly !
when I select "NO" Trigger is not create .

when this error occure < I mUst shutDown My system and wait One hour and then work !

ALI

Report message to a moderator

Re: Problem with Create Trigger [message #288180 is a reply to message #288131]

Sat, 15 December 2007 08:20

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

A Program Unit Named P0_24_138600_00_00 already exist

Program unit isn't necessarily a trigger - it may be a procedure, function, package ... Did you make sure that such a PL/SQL procedure already exists? However, as I've never seen such an error, I can't help much. But I still wonder why would you choose such a name? What's wrong with, for example, 'P0_24_138600_00_01', or even 'trg_calculate_something' or 'prc_insert_details' or 'fun_find_status'? I believe it is easier to work with such names than the one you used.

Report message to a moderator

Re: Problem with Create Trigger [message #288238 is a reply to message #288180]

Sun, 16 December 2007 03:53

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

ThanQ LittleFoot

No . there is not Procedure Or Function Or ... with that Name!!

This Error Randomly .if In a from that Error ocoured , in another Day or 3 hour Later I can create Trigger !!!
when this error occoured I will STOP my work and go to My Home !
because in that day i can not create any Trigger !!

Regard
ALI

Report message to a moderator

Re: Problem with Create Trigger [message #288240 is a reply to message #288238]

Sun, 16 December 2007 04:20

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Amazing! Simply amazing!

I hope David will find some time to browse this forum and see your question. I'd really like to hear his opinion.

Report message to a moderator

For David ( Dj Martin ): Problem with Create Trigger [message #289033 is a reply to message #288240]

Wed, 19 December 2007 05:35

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

Hi David !

I and Little Foot Invite You to see this message

Regard
ALI

Report message to a moderator

Re: For David ( Dj Martin ): Problem with Create Trigger [message #289162 is a reply to message #289033]

Wed, 19 December 2007 22:42

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

Senior Member
Account Moderator

Try the good old Ctrl-Shft-k (Compile All) and see if that helps. Alternatively, convert the fmb to an fmt and back again. If you have 9i consider converting the fmb to xml, look for an 'object' that only has a 'beginning' and an 'end', delete this entry and convert back to fmb.

David

Report message to a moderator

Re: For David ( Dj Martin ): Problem with Create Trigger [message #289164 is a reply to message #289162]

Wed, 19 December 2007 22:55

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

Thanks David !
This Problem randomly ! and I have not problem in today ! if today problem occured , I will test your Reply .

REGARD
ALI

Report message to a moderator

Previous Topic:	Scroll Bar
Next Topic:	print form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 08:27:09 CDT 2024