Simple newbie question.-PLS HELP!
From: Aaron Miles <pontiff_at_aardvark.apana.org.au>
Date: 17 May 1999 10:11:40 GMT
Message-ID: <7hoq0s$cod$1_at_llama.teragen.com.au>
Howdy,
The small script I have is the following begin
insert into teachers(id) values (:teachers.f_id); end;
I get the error
FRM-40508 Oracle is unable to insert record. I have tried many variations on the script to make it work, none of which do I have tried declaring variables to make it work, like
declare
f_id varchar2(2);
...
insert into teachers (id) values (f_id); which does not work either. I goto sql*plus and I can insert happily, but try it from forms and it dies. Can you place any light on this subject. I know this question must be easy for Boffins like yourself, but I am not :-(
Date: 17 May 1999 10:11:40 GMT
Message-ID: <7hoq0s$cod$1_at_llama.teragen.com.au>
Howdy,
Great work on your book Oracle: A beginners guide. I am atrue beginner and read it in 3 days. Now I'm going through it again, trying to accomplish all the tasks you mention in your examples. I left the trail a little bit to see If I can make a form which had two buttons, one that finds data and one that add's new data. The finding data all works fine ,but the adding new data Does not. I can't figure out why, and the error message that I get does not do much for explaining it, and I was wondering if you could help me out for a second.
The small script I have is the following begin
insert into teachers(id) values (:teachers.f_id); end;
I get the error
FRM-40508 Oracle is unable to insert record. I have tried many variations on the script to make it work, none of which do I have tried declaring variables to make it work, like
declare
f_id varchar2(2);
...
insert into teachers (id) values (f_id); which does not work either. I goto sql*plus and I can insert happily, but try it from forms and it dies. Can you place any light on this subject. I know this question must be easy for Boffins like yourself, but I am not :-(
cheers.
Aaron
- Aaron Miles (aaron_at_impactcreativity.com.au)
- System Administrator - Impact Creativity Centre.
- HAVE: 1988 BMW 325i Executive.
- NEED: 321Bhp E36 M3 / E39 M5 - whatever comes first :-)
-- -- The Pontiff Quotes for this millennium: SHIN: A DEVICE FOR FINDING FURNITURE IN THE DARK Consciousness: that annoying time between naps. He who laughs last thinks slowest. Make it idiot proof and someone will make a better idiot.Received on Mon May 17 1999 - 12:11:40 CEST