Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
CREATE PROCEDURE RE39r (IN V_ID INTEGER, IN V_TYPE CHAR(2)) SPECIFIC RE39r DECLARE CUR1 CURSOR WITH RETURN TO CALLER FOR IF V_TYPE = 'CH' THEN select * from abc where id = V_ID; elseif V_TYPE = 'OM' THEN SELECT * FROM DEF WHERE ID = V_ID; ELSEIF V_TYPE = 'RI' THEN SELECT * FROM KLM WHERE ID = V_ID; END IF; OPEN CUR1; END P1
Join the community of 500,000 technology professionals and ask your questions.