problem with a function with error message MGR-00073

[dngaya]

I have a base oracle 8.0.5 installed on HP 11.0, when I execute the script of creating the functions starting from script below:

DROP FUNCTION GPFDBA.DATE_TO_HISTO;
-- BEGIN PL/SQL BLOCK (do not remove this line) --------------------------------
CREATE OR REPLACE FUNCTION GPFDBA.date_to_histo (odate in date) return number is
begin
-- Convert a Oracle date to a Portfolio date (nammed histodate)
return (-trunc(to_number(odate - to_date('14/09/1752','DD/MM/YYYY'))));
end;
-- END PL/SQL BLOCK (do not remove this line) ----------------------------------;


DROP FUNCTION GPFDBA.HISTO_TO_DATE;
-- BEGIN PL/SQL BLOCK (do not remove this line) --------------------------------
CREATE OR REPLACE FUNCTION GPFDBA.histo_to_date (hdate in number) return date is
begin
-- Convert a Portfolio date (nammed histodate) to Oracle date
return (to_date('14/09/1752','DD/MM/YYYY') + abs(hdate));
end;
-- END PL/SQL BLOCK (do not remove this line) ----------------------------------;


DROP FUNCTION GPFDBA.HISTO_TO_HEURE;
-- BEGIN PL/SQL BLOCK (do not remove this line) --------------------------------
CREATE OR REPLACE FUNCTION GPFDBA.histo_to_heure (hdate number) return character is
begin
-- Convert a Portfolio hour (nammed histodate) to character as "23:59:59"
-- Return space if hdate is too large
if abs(hdate) > 86399 then return ' '; end if;
return (to_char(to_date(abs(hdate),'SSSSS'),'HH24:MI:SS'));
end;
-- END PL/SQL BLOCK (do not remove this line) ----------------------------------;

I receive the following error message:

Statement processed.
MGR-00073: Warning: FUNCTION GPFDBA.DATE_TO_HISTO created with compilation errors.

how to make for resoudre this problem? .
thank you for your assistance

[Steve Steel]

Hi

http://rhea.redhat.com/bboard-archive/webdb/000Hml.html

Should point you in the right direction.


Steve Steel

[Yogeeraj_1 · Accepted solution]

hi,

You may be facing a BUG in the version of Oracle!

try to connect as user GPFDBA

and run the following:
=======================================
DROP FUNCTION DATE_TO_HISTO;
-- BEGIN PL/SQL BLOCK (do not remove this line) --------------------------------
CREATE OR REPLACE FUNCTION date_to_histo (odate in date) return number is
begin
-- Convert a Oracle date to a Portfolio date (nammed histodate)
return (-trunc(to_number(odate - to_date('14/09/1752','DD/MM/YYYY'))));
end;
-- END PL/SQL BLOCK (do not remove this line) ----------------------------------;


DROP FUNCTION HISTO_TO_DATE;
-- BEGIN PL/SQL BLOCK (do not remove this line) --------------------------------
CREATE OR REPLACE FUNCTION histo_to_date (hdate in number) return date is
begin
-- Convert a Portfolio date (nammed histodate) to Oracle date
return (to_date('14/09/1752','DD/MM/YYYY') + abs(hdate));
end;
-- END PL/SQL BLOCK (do not remove this line) ----------------------------------;


DROP FUNCTION HISTO_TO_HEURE;
-- BEGIN PL/SQL BLOCK (do not remove this line) --------------------------------
CREATE OR REPLACE FUNCTION histo_to_heure (hdate number) return character is
begin
-- Convert a Portfolio hour (nammed histodate) to character as "23:59:59"
-- Return space if hdate is too large
if abs(hdate) > 86399 then return ' '; end if;
return (to_char(to_date(abs(hdate),'SSSSS'),'HH24:MI:SS'));
end;
-- END PL/SQL BLOCK (do not remove this line) ----------------------------------;
============================================

hope this helps!
regards
Yogeeraj