SQL & PL/SQL

Hi Everyone,

I have inherited a VBA application that I am now converting to PL/SQL. This functionality includes a lot of mathematically functions, most of which I have been able to convert quite easily.

Now I am just stuck on two functions ...

ARCSIN
and
ARCTAN

... which apparently both exist and are supported by Oracle.

However, when I try to implement them (e.g. SELECT ARCSIN(0.1837) FROM DUAL ) I get the message ...

SQL> select arctan(1.5) from dual;
select arctan(1.5) from dual
*
ERROR at line 1:
ORA-00904: "ARCTAN": invalid identifier

... so I am wondering whether this function needs to be declared/activated in some way?

Or is it not available in our installation of Oracle ...

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0

If I could get these two functions working, then that would finish off the last of the functions.

Many thanks for any tips that you can give me.

Regards,
Alan Searle

Cologne, Germany

PS: I have the formulas so I could program these functions myself. But it would be much easier to use oracle's version.