| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
|||
Udpate Insert (inside a LOOP)Hey There,
I am trying to do an udpate or insert but it does not seem to work and I beleive it is because i am inside a LOOP. Here is the code. I need help please. nBLANK NUMBER := NULL ; BEGIN SELECT INPUT_ID.nextval INTO nBLANK FROM qualstat_month; admin_tokenizer.tokenize(sLIST_JOBKNOW,oListJobkno wToken,nTokenCount); admin_tokenizer.tokenize(sLIST_CALLQUAL,oListCallq ualToken,nTokenCount); admin_tokenizer.tokenize(sLIST_ORDQUAL,oListOrdqua lToken,nTokenCount); admin_tokenizer.tokenize(sLIST_INPUT_ID,oListInput idToken,nTokenCount); FOR i IN 1..nTokenCount LOOP sJOBKNOW := to_char(oListJobknowToken(i)); sCALLQUAL := to_char(oListCallqualToken(i)); sORDQUAL := to_char(oListOrdqualToken(i)); sINPUT_ID := to_char(oListInputidToken(i)); IF sINPUT_ID IS NULL THEN EXIT; END IF; UPDATE table2 set job_know = sJOBKNOW, call_qual = sCALLQUAL, ord_qual = sORDQUAL, modified_date = sysdate, modified_by = sLoginId where input_id = sINPUT_ID; IF nBLANK IS NULL THEN INSERT INTO table2 (call_qual, ord_qual, job_know, input_id, modified_date, modified_by) VALUES (sCALLQUAL, sORDQUAL, sJOBKNOW, sINPUT_ID, sysdate, sLoginId); END IF; END LOOP; |
|
Be the first to answer this question! Click on the 'Post Reply' button below.
|