Re: Warning: Package body created with compilation errors

From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Fri, 30 Jan 2004 05:52:50 -0600
Message-ID: <Xns9480460BA6C69ScottatTheMattesFami@216.196.97.132>

walkersj_at_hotmail.com (SJWalker) wrote in news:fcf70964.0401291510.23e4d7c3_at_posting.google.com:

> /**********************************************************/
> CREATE OR REPLACE PACKAGE GenRand AS
> PROCEDURE ChangeSeed(p_NewSeed IN NUMBER);
> END GenRand;
>
> CREATE OR REPLACE PACKAGE BODY GenRand AS
> v_Seed NUMBER := 1;
>
> PROCEDURE ChangeSeed(p_NewSeed IN NUMBER) IS
> BEGIN
> v_Seed := p_NewSeed;
> END ChangeSeed;
>
> BEGIN
> ChangeSeed(TO_NUMBER(TO_CHAR(SYSDATE, 'SSSSS')));
> END GenRand;
> /**********************************************************/
>

It compiles clean on 9.2.

What version of Oracle? What was the error msg? Received on Fri Jan 30 2004 - 05:52:50 CST