Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Oracle Toolkit Version 10.1.2.0.2 (Production)
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 10.1.2.0.2 - Production
Oracle Virtual Graphics System Version 10.1.2.0.2 (Production)
Oracle Tools GUI Utilities Version 10.1.2.0.2 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.4.0 Production
hi there! I have a problem where i have on control with one button and when i click the button the trigger code is:
DECLARE
BEGIN
IF :SYSTEM.MODE = 'NORMAL' THEN
ENTER_QUERY;
END IF;
GO_BLOCK('PEGAWAI');
EXECUTE_QUERY;
END;
in the table-based data block, i have a block named PEGWAI with item NAMA, it the pre-query trigger i put this criteria:
:PEGAWAI.NAMA := 'ORA';
Unfortunately, i got that error "FRM 41003 - the function cannot be perfomed here". What's wrong with my code, tx in advance.