sequence generation error

i'm working on a third year computing project which has been ongoing for the last 4 years.  the previous years work supposedly ran with no errors but after trying to get it to work all the trigger code compiles fine but when a single form is ran and a project is selected a frm-40911 error occurs i think it is just a simple error that i do not know how to fix if someone could just send me the most common reasons for this error and how to fix them.

 cheers
     Ishmael
ishmaelAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
yesnaudConnect With a Mentor Commented:
Well It's quiet difficult to solve your problem because we don't really know what's this all about... anyway if it worked before there is surely a installation problem somewhere. The FRM 40911 is problem on insert. When you create a new record you probably generate an id for that record using a sequence generation number. Well that sequence is either missing or not accessible to you. if the sequence exists then maybe you should look if you have privileges on that sequence generation.... ask your dba.

yesnaud@fdgroup.co.uk
0
 
mordiCommented:
What Oracle Forms version are you running?
0
 
ishmaelAuthor Commented:
im running oracle forms 4.5
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
mordiCommented:
Press the display error key after you get the error, to see the expanded error text
0
 
ishmaelAuthor Commented:
i did that ages ago and all that it says is that there is a frm-40911 sequence generation error and then after going through the help of sql and finding that specific error i still cant fix the problem it doesnt tell me the specific reason for the error.
0
 
ishmaelAuthor Commented:
thanks to mordi and yesnaud for the help
0
All Courses

From novice to tech pro — start learning today.