Bulk insert help
Hi All,
Please help me to re-write the procedure with bulk insert...
CREATE OR REPLACE Procedure Create_Ageing_Details(I_CompanyId Varchar2, I_UserId Varchar2, I_AgeId Varchar2, I_BaseDate Varchar2 ,I_Posted Varchar2) asbegin Delete from Ageing_Details_Temp where Company_Id = I_CompanyId and User_Id = I_UserId; Insert Into Ageing_Details_Temp(Company_Id, Gl_code, Branch_id, Refno, Tran_Date, Details, Sm_Code, Sm_Name, cucode, cuname, Age1, Age2, Age3, Age4, Age5, Age6, Age7, Age8, Age9, Age10, Un_Alloc_Amt, Net_Total, Age_Heading1, Age_Heading2, Age_Heading3, Age_Heading4, Age_Heading5, Age_Heading6, Age_Heading7, Age_Heading8, Age_Heading9, Age_Heading10, User_Id) (Select Company_Id, Gl_Code, Branch_id, refno,tran_date,details,sm_Code, Initcap(sm_Name) sm_Name, CuCode, initcap(CuName) CuName, Age1, Age2, Age3, Age4, Age5, Age6, Age7, Age8, Age9, Age10, Un_Alloc_Amt, (nvl(age1,0) + nvl(age2,0) + nvl(age3,0) + nvl(age4,0) + nvl(age5,0) + nvl(age6,0) + nvl(age7,0) + nvl(age8,0) + nvl(age9,0) +
0