what type of this in oracle?

Question

i revice my friend's script,

i got this line in oracle query :

select name, contact.utils.occupation_abbr(occupation)
from contact.staff

and i got :
*"CONTACT"."UTILS"."OCCUPATION_ABBR": invalid identifier*

this machine is not the original machine,
i think i miss copy something from the original machine.
I see in trigger or function list on the original machine and i don't find this there.

Any suggestion what i left?

== A BIT TRICKY ==

i get the function from packages body,
then i run the query and make it as function and it now become function :D

Answer 1

It's a PL/SQL package.

The package name is UTILS and the function that is called is named OCCUPATION_ABBR

You need to copy the whole package from the other system, only the function is not enough.

The package can be found in the schema (user) CONTACTS

Answer 2

That looks like a user defined function. You'll need to source it from the original machine.