Re: Problems creating a procdure

From: <eiuepny_at_my-dejanews.com>
Date: Fri, 21 May 1999 21:33:03 GMT
Message-ID: <7i4jef$es9$1@nnrp1.deja.com>

Paul,

If it's a PACKAGE and not a PROCEDURE, your AS should be an IS:

CREATE OR REPLACE PACKAGE calcSum IS

Scott

In article <37457fc3_at_newsread3.dircon.co.uk>, "Paul Davies" <cobalt_at_dircon.co.uk> wrote:
> I'm trying to create a procedure in iSQL and am getting this errors:
>
> CREATE OR REPLACE PACKAGE calcSum AS
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01578: ORACLE data block corrupted (file # 1, block # 10088)
> ORA-01110: data file 1:
> '/root/devel/oracle/database/datafiles/system1.dbf'
>
> Can someone please tell me what to do about this. Other procedures are
> created just fine.
>
> Thanks
>
> Paul
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 21 1999 - 16:33:03 CDT