set current schema REPL;
create table TEST (ID INT, NAME VARCHAR( 32 ));
INSERT INTO TEST VALUES ( 1 ,'Test');


CREATE OR REPLACE PROCEDURE REPL.SP_TEST (inputid int)
AS
v_name varchar( 32 );
BEGIN
				select NAME INTO v_name from REPL.TEST where id = inputid;
				if (value(v_name,' ')=' ') then 
					select 'Default' into v_name from dual;				
				end if;
				DBMS_OUTPUT.PUT_LINE(v_name); 
END;
/

CREATE OR REPLACE PROCEDURE REPL.SP_TEST (inputid int)
AS
v_name varchar( 32 );
emp_refcur      SYS_REFCURSOR;
BEGIN
				OPEN emp_refcur FOR 'select NAME from REPL.TEST where id = :inputid' USING inputid;
				FETCH emp_refcur INTO v_name;
				if emp_refcur%NOTFOUND then 
					v_name := 'Default';				
				end if;
				DBMS_OUTPUT.PUT_LINE(v_name); 
				CLOSE emp_refcur;
END;
/