Re: FRM-40508 Error ?

In article <3o823e$doo_at_aplinfo.jhuapl.edu> Stan Novinsky <stan_novinsky_at_jhuapl.edu> writes:
>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

Basically this error FRM-40508 is a table access error.

My question to you is /* check to see if */ "Are you the same Oracle username in SQL*Forms /*Runform*/,  as you are in SQL*Plus?"

When I'm in SQL*Plus or SQL*Forms (Design), I am USER_A. When I'm in SQL*Forms (Runform), I am USER_B.

I do this for all of my databases because all of my users access Oracle by their VMS username /* OPS$vms_username */

Hope this helps, Stan.

James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!" Received on Fri May 05 1995 - 00:00:00 CEST