Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger Problem
mhakimjavadi_at_hotmail.com (Mohammad) wrote in message news:<cc59b627.0306110752.11625485_at_posting.google.com>...
> Hi Everybody,
> I try to create a Trigger but I got this following error :
>
> Warning: Trigger created with compilation errors.
>
> SQL> SHOW ERROR
> Errors for TRIGGER TRI1:
> 6/3 PL/SQL: SQL Statement ignored
> 6/50 PL/SQL: ORA-00942: table or view does not exist
>
> I dont know what is meaning of this error because the table exists.
>
> Here it is my code:
>
> SQL> CREATE OR REPLACE TRIGGER TRI1 BEFORE INSERT
> 2 ON SOBSBGI FOR EACH ROW
> 3 DECLARE
> 4 STAT VARCHAR(3);
> 5 ZIPC VARCHAR(10);
> 6 BEGIN
> 7 ZIPC := :NEW.SOBSBGI_ZIP;
> 8 SELECT GTVZIPC_STAT_CODE INTO STAT FROM SATURN.GTVZIPC
> 9 WHERE GTVZIPC_CODE = ZIPC;
> 10 :NEW.SOBSBGI_STAT_CODE := STAT;
> 11 END;
>
>
> Please help me and tell me what is the problem.
>
> Thanks
> Hakim
Hi
Thanks for your reply. Yes the user has permission. Please advise
Thanks
Moahmmad
Received on Thu Jun 12 2003 - 08:30:06 CDT