Reference a package in a script

[kwartz]

I have a package with various functions and I have written a script with various blocks to test the functions in the package. When I run the script on my machine it works fine but wouldn't work on any other machine. It says
eg. ISNUMERIC must be declared. I am told it's because I don't reference the package in the script. Can anybody help.

Thanks

[debasisdas]

Are you accessing same database on both the machines ?

[amitpatel66]

I have a package with various functions and I have written a script with various blocks to test the functions in the package. When I run the script on my machine it works fine but wouldn't work on any other machine. It says
eg. ISNUMERIC must be declared. I am told it's because I don't reference the package in the script. Can anybody help.

Thanks

You need to call the function ISNUMERIC by saying package_name.IS NUMERIC

Did you do this way?

[kwartz]

Tried that and it worked. I had to do that in each of the blocks that I called the functions

[kwartz]

Are you accessing same database on both the machines ?

Yes, the database is on more than one machine

[amitpatel66]

Tried that and it worked. I had to do that in each of the blocks that I called the functions

Yes ofcourse you need to do that...no other option.....