Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

i am new to pl/sql help me get to solve this error

Aravind Kumar SekarSep 16 2015 — edited Sep 16 2015

the syntax for creating the HOME table and home details

create table home (F_NAME VARCHAR2(25),M_NAME VARCHAR2(25),C_NAME VARCHAR2(25));


create table home (F_NAME VARCHAR2(25),M_NAME VARCHAR2(25),C_NAME VARCHAR2(25));

the program for trigger

CREATE OR REPLACE TRIGGER HOME_BEFORE_DELETE

BEFORE INSERT

ON HOME

FOR EACH ROW

DECLARE

V_USERNAME VARCHAR2(25);

BEGIN

SELECT USER INTO V_USERNAME FROM DUAL;

INSERT INTO HOME_DETAILS

(F_NAME, M_NAME, C_NAMEĀ  )

values

(:old.F_NAME,

:old.M_NAME,

:old.C_NAME ,V_USERNAME);

END



when executing it shows

ORA-24344: success with compilation error

This post has been answered by Manjusha Muraleedas on Sep 16 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2015
Added on Sep 16 2015
4 comments
546 views