Thread: Trigger and function problem
View Single Post
  #2 (permalink)  
Old 07-25-10, 23:30
anacedent anacedent is offline
Registered User
  
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,147
>i an facing problem with the trigger. plz give me a solution how i can do this
Please clarify EXACTLY what "problem" you face.

BTW, you have a typo error in posted code.
>var:=chcek1(:new.room_no);
not as above but as below
var:=check1(:new.room_no);

>dbms_output.put_line('The room is not available');
line above makes NO sense, because PL/SQL runs deep inside RDBMS engine & no user will ever see it.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote