Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: function compilation error?

Re: function compilation error?

From: Mark Gumbs <mgumbs--AT--hotmail.com>
Date: Mon, 24 May 1999 13:38:12 +0100
Message-ID: <3749460c.0@145.227.194.253>


If you recompile in sql*plus and issue a show errors, it should tell you where the error occured.
Also show errors package body for the package body. Don't forget to set serverout on!

M

Jerwynn wrote in message <37492F2F.2160457E_at_i-manila.com.ph>...
>Hi,
>
>If ever I have some problems with "create function" script
>SQL plus shows a warning message saying there were compilation errors...
>
>how do i know what specific error occurred? does oracle show what syntax
>is incorrect?
>
>
>Thanks.
>
>Jerwynn
>
Received on Mon May 24 1999 - 07:38:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US