I need to calculate near about *30 types* of different calculations(formulas e.g:(capcost * rate / 100) + (ob + (ob * interestrate / 100)) which I am storing in a table ) for 2,000 employees. SQL> Also, as DomBrooks said, Why you need a NDS ?ġ. PLS-00201: identifier 'SALARY' must be declaredĢ lv_formula VARCHAR2(200) := ':bind_sal*100'

To illustrate that:Ģ lv_formula VARCHAR2(200) := 'salary*100' Ħ SELECT sal INTO salary FROM emp WHERE empno = 7839 ħ EXECUTE IMMEDIATE 'BEGIN :out := ' || lv_formula || ' END ' You have not bind the IN parameters in EXECUTE IMMEDIATE. Here i m passing the parameter through my form builder and calling this procedure.īilly already pointed out the error on your code. INTO periodfrom, periodto, rcsrate, length_area, rate,Įrate, feamount, interestrate, fiamount, penaltyrateĮXECUTE IMMEDIATE 'BEGIN :out := ' || lv_formula || ' END ' SELECT b.periodfrom, b.preiodto, b.rcsrate, b.length_area, b.rate,ī.erate, b.feamount, b.interestrate, b.fiamount, b.penaltyrate WHERE billtyp = l_type AND refno = l_agtmnt Lastbillraised, noofstaff, items, area, LENGTH, INTO refno, billtyp, ob, status, dueamt, duedate,įrequency, lastrevrate, penaltyamt, accounted, SELECT a.refno, a.billtyp, a.ob, a.status, a.dueamt, a.duedate,Ī.frequency, a.lastrevrate, a.penaltyamt, a.accounted,Ī.lastbillraised, a.noofstaff, a.items, a.area, a.LENGTH, TO_NUMBER ((capcost * rate / 100) + (ob + (ob * interestrate / 100))) Penaltyrate afxbrrate.penaltyrate%TYPE - := 0 Interestrate afxbrrate.interestrate%TYPE - := 0 Lastbillraised afxbrmst.lastbillraised%TYPE Ĭapcost NUMBER afxbrmst.capcost%TYPE :=1 įeamount afxbrrate.feamount%TYPE - := 0 Penaltyamt afxbrmst.penaltyamt%TYPE - := 0 Lastrevrate afxbrmst.lastrevrate%TYPE - := 0 1.7K Training / Learning / Certificationīut i still didn't get my desired solution so i am pasting my whole plsql code here.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.

Capcost software