Function Problem

[jcasas23]

Someone knows why Oracle 7.3.4 show me this error:

The following error has occurred:

ORA-06550: line 5, column 19:
PLS-00905: object ES344.P_INI is invalid
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

When I execute the next function:

create or replace function es344.p_ini
(
ncia number,
init date
)
return number is
per number;
begin
begin
select bp.period into per
from devcbs.b_periods bp
where bp.cia = ncia
and bp.init_date = init;
exception when no_data_found
per := 0;
end;
return (per);
end p_ini;

 

[SantaMufasa]

K'zaz,

What happens after you say:

ALTER function es344.p_ini compile;

Generally, the error you received comes from some change that is external to the function. Just recompile it with the above command and see if there are and remaining errors.

Mufasa
(aka Dave of Sandy, Utah, USA @ 15:32 (18Oct04) UTC (aka "GMT" and "Zulu"), 08:32 (18Oct04) Mountain Time)

 

[jcasas23]

Mufasa, I did as you say, and after create the function, I recompile it with the sentence that you give me, and does not work, the function still show me the same error, and it still create with compilation errors.

After I run Alter show me this:

Warning: Function altered with compilation errors.

that it is the exactly warning that show me when create the function.

What do you think?
thank in advance for your advises.

 

[carp]

I think that after you try to compile the function and get that message, you should enter

show error

(assuming you are using SQL*Plus). This should show you what the error is.