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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mordiCommented:
What Oracle Forms version are you running?
0
ishmaelAuthor Commented:
im running oracle forms 4.5
0
mordiCommented:
Press the display error key after you get the error, to see the expanded error text
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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
yesnaudCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ishmaelAuthor Commented:
thanks to mordi and yesnaud for the help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.