Dynamic Query String

[JayM]

i found it..

here's what i changed the code to..

IF LENGTH(IN_PROGRAM) > 0 THEN
	 	dbms_output.PUT_LINE(IN_PROGRAM);
 	    qry_str := qry_str || ' AND OT.ADMINISTRATION = ' || ''''||UPPER(IN_PROGRAM)||'''';
	 END IF;