Hi,

At September 3, 2003, 19:42, Peppe Polpo wrote:

> wrote:

>> Unless you tell us what exaclty did you do

> step 1:

> create procedure test
> returns
> (result integer)
> as
> begin
> result=1;
> suspend;
> end

> step 2:

> create procedure test1
> returns
> (result integer)
> as
> begin
> select result from test into :result;
> suspend;
> end

> step 3:

> (try procedure test1)

> select result from test1

> Result=1 (as expected)

> step 4:

> alter procedure test
> returns
> (result integer)
> as
> begin
> result=2;
> suspend;
> end

> step 5:

> (try procedure test1)

> select result from test1

> Result=1 (instead of the expected value 2)

> Isn't this a bug ?

Do you COMMIT after each steps?
Are you the only user logged in?
Which username are you using to log in? If it's not SYSDBA, is it the
owner of the database?
What happens if you log off then login again?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)