Re: HELP ! Whats wrong with this procedure ??

varchar2 as a parameter doesn't take a length specification. Remove (26)
and it should compile. It looks like though the procedure should return something.

Hth,

Sybrand Bakker, Oracle DBA

Martin T. <mthgd_at_tdk.dk> wrote in message news:378c5ffe.98751497_at_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:39:09 CDT