Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
create or replace PROCEDURE ALL_TBLES_PRC /* NAME: TBLES DESCRIPTION: -- This is to select ALL data from Project tables. Parameters will be the TABLE NAME and PUB_ID */ ( PARAM_0 IN NUMBER, --USER PARAM_SYSFLAG IN NUMBER, --NUMBER PARAM_1 IN VARCHAR2, -- TABLE NAME PARAM_2 IN NUMBER, -- PUB ID P_RECORDSET OUT SYS_REFCURSOR ) AS BEGIN OPEN P_RECORDSET FOR SELECT * FROM 'AAD.'|| PARAM_1 WHERE ID = PARAM_2; EXCEPTION WHEN NO_DATA_FOUND THEN NULL; END ALL_TBLES_PRC; /* */
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.