Division in PL/SQL

I am unable to perform a simple division in PL/SQL.
I am new to PL/SQL and try the following operation and but my Stored Procedure seems to break at this point.

cRec.RC_FACTOR1 never contains zero.

vF1 := (cRec.RC_FACTOR2 - cRec.RC_FACTOR1) / cRec.RC_FACTOR1;

gkersterAsked:
Who is Participating?
 
gjutrasCommented:
are all of cF1 cRec.RC_FACTOR2 and cRec.RC_FACTOR1 of a floating point like number?
if they aren't
cast each one that isn't as
cast(vF1 as number)
and try putting the whole expression in a cast((expression) as number)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.