Re: FRM-40508 Error ?

Stan Novinsky (stan_novinsky_at_jhuapl.edu) wrote:
: On a FORM I have a Block that contains 6 records that I am
: attempting to commit to the database. The block is defined with
: the INSERT, UPDATE, DELETE, QUERY attributes on. When I execute the
: COMMIT, I receive
 

: FRM-40508: ORACLE error-- unable to INSERT record.
 

: However, if I execute an INSERT and COMMIT from SQLPLUS outside
: of the FORM, it works fine.
 

: This Forms 4.0, Oracle7.1, OpenVMS 6.1.
 

: Any Ideas..
 

: Thanks
 

: stan_novinsky_at_jhuapl.edu

  See what is the Insert error by displaying error. That'll give a good   clue as to what is going wrong. Are there any database triggers that will   run only when using the form.

  I hope this helps.

--
--------------------------------------------------------------------------------
Kannan 
Email: skannan_at_fs.com

The above are my own comments and opinion. They do not purport that of anybody 
else.
--------------------------------------------------------------------------------