CODEWITHSUNDEEP
plsql
Satyabrata Kar
Satyabrata Kar

Reputation: 11

PLS-00103: Encountered the symbol "INSERT"

I executing the Below PLSQL Query.

SET SERVEROUT ON;
Create or Replace Trigger bi_Shippers
Before INSERT on Shippers
For EACH ROW
ENABLE
DECLARE
v_User VARCHAR2(20);
BEGIN
SELECT user INTO v_User from Dual;
DBMS_OUTPUT.PUT_LINE('You Just inserted a Line'||v_User);
END;

INSERT into shippers(shipperid) VALUES(5);

I am Getting the below Error. Trigger BI_SHIPPERS compiled

LINE/COL ERROR

8/1 PLS-00103: Encountered the symbol "INSERT" Errors: check compiler log

Please help on this as I am new to PLSQL.``

Upvotes: 1

Views: 5209

Answers (1)

Ori Marko
Ori Marko

Reputation: 58772

You need to end procedure with Slash (`/'):

END;
/
INSERT into shippers(shipperid) VALUES(5);

Upvotes: 5

Related Questions