convert different data types (string to double)?

hi all!

i have a calculator that i created in pl/sql with oracle forms 9i. everything works fine, the different data types (int, varchar2 etc) dont seem the hurt themselves.

but there's a problem: when i try to divide, then i have unhandled error exceptions. it seems there we have probs with the datatypes.

can somebody tell me how to convert a numerical string to a double variable?

thx & gr33tz
j0sh

If you deal with Oracle 9i, then the cast function is available.

Please try:
select cast('11' as NUMBER) from dual;

Regards,
Dan

i have no sql queries, it's just a Forms application. is there a function for this like "cast"?

thank you.