Oracle Trigger help NEEDED!!!

I was hoping that someone in this forum might be able to assit me. I have for the life of me been tring how to create this trigger:

CREATE OR REPLACE TRIGGER prop_sold
AFTER INSERT ON Sale
FOR EACH ROW
BEGIN
IF PROP_ID := Property.PROP_ID THEN
UPDATE Property
Set Property.Sold = 'Y'
WHERE Sale.PROP_ID == Property.PROP_ID
ENDIF;
END;
/


When I insert a row into one table I want to update a column in the another with a Y. It seems simple enough but I can't figure it out for the life of me.

The following is what my two tables look like:

SALE

Name Null? Type
----------------------------------------- -------- ----------------------------
SALE_ID NOT NULL VARCHAR2(6)
SALES_AGENT NOT NULL VARCHAR2(6)
SALE_PRICE NOT NULL NUMBER
CUST_ID NOT NULL VARCHAR2(6)
PROPERTY_ID NOT NULL VARCHAR2(6)
DATE_CREATED NOT NULL TIMESTAMP(6)
DATE_MODIFIED NOT NULL TIMESTAMP(6)

PROPERTY

Name Null? Type
----------------------------------------- -------- ----------------------------
PROPERTY_ID NOT NULL VARCHAR2(6)
LISTING_AGENT NOT NULL VARCHAR2(6)
RESIDENCE_TYPE NOT NULL VARCHAR2(2)
NEW_PROPERTY NOT NULL CHAR(1)
EXISTING_PROPERTY NOT NULL CHAR(1)
LISTING_PRICE NOT NULL NUMBER(38)
NUM_BEDROOMS NUMBER
NUM_BATHROOMS NUMBER
SQ_FT NUMBER
ADDR_ID NOT NULL VARCHAR2(6)
DATE_CREATED NOT NULL TIMESTAMP(6)
DATE_MODIFIED NOT NULL TIMESTAMP(6)
SOLD CHAR(1)

Are you using Oracle? It does not seem that it is written in Oracle PL/SQL. Try to check out this code:

CREATE OR REPLACE TRIGGER prop_sold
AFTER INSERT ON Sale
FOR EACH ROW
BEGIN

UPDATE Property
Set SOLD = 'Y'
WHERE Property.PROPERTY_ID = new.PROPERTY_ID;

END;
/