Developer 6.0 Data Block Wizard
From: Eon Pike <rpike_at_csuchico.edu>
Date: Thu, 10 May 2001 16:49:53 -0700
Message-ID: <3AFB2921.9F308D58_at_csuchico.edu>
Date: Thu, 10 May 2001 16:49:53 -0700
Message-ID: <3AFB2921.9F308D58_at_csuchico.edu>
I am using Developer 6.0 and Oracle 8i. I am using the Form Builder
Data
Block Wizard and Layout Wizard together.
Question:
How do I stop the Wizard from adding Double Quotes around my Not Null
constrains
and yet still enforce data integrity?
When I run my Form here is what happens:
The below information is from the PL/SQL Editor. (see error displayed below)
--
- Begin default enforce data integrity constraint SYS_C002288 section
--
if not( ":STUDENT.SNAME" IS NOT NULL ) then message( 'WHEN-VALIDATE-ITEM trigger failed on field - ' || :system.trigger_field ); raise form_trigger_failure; end if;
--
- End default enforce data integrity constraint SYS_C002288 section
--
ERROR MESSAGE:
Error 201 at line4, column9
identifier ':STUDENT.SNAME' must be declared
Error 0 at line4, column1
statement ignored.
I take the double quotes out and it will compile. Any help or direction is greatly appreciated.
-Melody Pike
coffee_at_csuchico.edu
Received on Fri May 11 2001 - 01:49:53 CEST