SET SERVEROUT ON

CREATE PROCEDURE PRC$FOO
IS
BEGIN
  DBMS_OUTPUT.PUT_LINE('Procedure foo called');
END;
/

CREATE TABLE mhe_foo(id NUMBER)
/

CREATE TRIGGER trg_mhe_foo
BEFORE INSERT ON mhe_foo
BEGIN
  dbms_output.put_line('Trigger on mhe_foo called.');
END;
/


BEGIN
  EXECUTE IMMEDIATE 'CALL prc$foo()'; -- procedure call
END;
/

BEGIN
  EXECUTE IMMEDIATE 'CALL trg_mhe_foo()'; -- trigger call, will fail.
END;
/


DROP TABLE mhe_foo
/


DROP PROCEDURE PRC$FOO
/

SQL> select banner from v$version
  2  /

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE    9.2.0.6.0       Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production

SQL> @C:\useful\orafaq

Procedure created.


Table created.


Trigger created.

Procedure foo called

PL/SQL procedure successfully completed.

BEGIN
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name
ORA-06512: at line 2



Table dropped.


Procedure dropped.