HELP ! Whats wrong with this procedure ??

From: Martin T. <mthgd_at_tdk.dk>
Date: Wed, 14 Jul 1999 10:06:49 GMT
Message-ID: <378c5ffe.98751497@news.inet.tele.dk>

Hi there !

Is there anybody who can help me ! What is the matter with this

procedure.................

Best regards
           Martin T

SQL> CREATE PROCEDURE sam.kis_addr(p_kis_nr in varchar2(26))   2 AS
  3 BEGIN
  4 SELECT DISTINCT cdmcaa.addr1, cdmpcode.postcode, cdmpcode.town, cdmcaa.id
  5 FROM cdmcomp, cdmcaa, cdmpcode, installation   6 WHERE cdmcomp.kis_nr = p_kis_nr
  7 AND cdmcomp.id = installation.primarycompany   8 AND installation.primaryaddress=cdmcaa.id   9 AND cdmcaa.primarypostcode = cdmpcode.id  10 AND cdmcaa.delu is null
 11 AND cdmpcode.delu is null
 12 AND cdmcomp.delu is null
 13 AND installation.delu is null
 14 ORDER BY cdmpcode.postcode, cdmcaa.addr1;  15 end;
 16 /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE SAM.KIS_ADDR:

LINE/COL ERROR

---

1/44 PLS-00103: Encountered the symbol "(" when expecting one of the

   following:
   := . ) , @ % default
   The symbol ":=" was substituted for "(" to continue. Received on Wed Jul 14 1999 - 05:06:49 CDT