How do I qualify a function or procedure call to indicate that it
should be at global scope? I have my own scn_to_timestamp()
in a package that needs to call the default global function of
the same name.

Many TIA!
Mark

create or replace package px as
function scn_to_timestamp(scn number) return timestamp;
end px;

create or replace package body px as
function scn_to_timestamp(scn number) return timestamp is
begin
-- how do I qualify this to refer to the global function?
return scn_to_timestamp(scn);
end;
end px;

--
Mark Harrison
Pixar Animation Studios

mh (AT) pixar (DOT) com schrieb:
return sys.scn_to_timestamp(scn);

But what is the purpose of such wrapper?

Best regards

Maxim

--
Why make things difficult, when it is possible to make them cryptic
and totally illogical, with just a little bit more effort?

Aksel Peter Jørgensen

Maxim Demenko <mdemenko (AT) gmail (DOT) com> wrote:
ah, perfect, thanks!

I have an hourly cron job that captures the current time and
scn to a table. So, if the requested scn is out of the range
of the current system logs, I can look up the requested time
in my table.

It's quite nice, we can see the update times of records for
as far back as we have the recorded timestamps.

Thanks again,
Mark

--
Mark Harrison
Pixar Animation Studios

On Mon, 06 Jul 2009 00:39:01 GMT, mh (AT) pixar (DOT) com wrote:

Sigh...
Some people will never learn.
Your system must be glued together by 100 percent of crap and bullshit
solutions.
Luckily I'm not the consultant, who needs to clean out the mess in the
near future.

--