PL/SQL (MOSC)

MOSC Banner

Bulk insert help

edited Oct 18, 2019 5:01AM in PL/SQL (MOSC) 14 commentsAnswered

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) +

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center