Home » Developer & Programmer » Forms » Problem with Create Trigger (Forms 6i)
Problem with Create Trigger [message #288131] Sat, 15 December 2007 00:16 Go to next message
alijeyan
Messages: 180
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
Re: Problem with Create Trigger [message #288180 is a reply to message #288131] Sat, 15 December 2007 08:20 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
Re: Problem with Create Trigger [message #288238 is a reply to message #288180] Sun, 16 December 2007 03:53 Go to previous messageGo to next message
alijeyan
Messages: 180
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
Re: Problem with Create Trigger [message #288240 is a reply to message #288238] Sun, 16 December 2007 04:20 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
For David ( Dj Martin ): Problem with Create Trigger [message #289033 is a reply to message #288240] Wed, 19 December 2007 05:35 Go to previous messageGo to next message
alijeyan
Messages: 180
Registered: January 2007
Location: IRAN
Senior Member
Hi David !

I and Little Foot Invite You to see this message

Regard
ALI
Re: For David ( Dj Martin ): Problem with Create Trigger [message #289162 is a reply to message #289033] Wed, 19 December 2007 22:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: For David ( Dj Martin ): Problem with Create Trigger [message #289164 is a reply to message #289162] Wed, 19 December 2007 22:55 Go to previous message
alijeyan
Messages: 180
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
Previous Topic: Scroll Bar
Next Topic: print form
Goto Forum:
  


Current Time: Thu Dec 08 00:20:55 CST 2016

Total time taken to generate the page: 0.13359 seconds