Jump to content

utility of pl word in use of pl/sql

gabrielsimon's Photo
Posted Aug 31 2010 07:57 AM
3643 Views

hi my name is simon
i'd would like to know if pl word i see in syntax of procedure or function, reading the best pl/sql practise guide is wrapper around dbms_output else how is it used

here is an copy of the procedure

CREATE OR REPLACE PROCEDURE genlookup (tab IN VARCHAR2, col IN VARCHAR2)
IS
l_ltab VARCHAR2 (100) := LOWER (tab);
l_lcol VARCHAR2 (100) := LOWER (col);
BEGIN
pl ('CREATE OR REPLACE FUNCTION ' || l_ltab || '_row_for (');
pl (' ' ||
l_lcol || '_in IN ' || l_ltab || '.' || l_lcol || '%TYPE)');
pl (' RETURN ' || l_ltab || '%ROWTYPE');
pl ('IS');
pl (' retval ' || l_ltab || '%ROWTYPE;');
pl ('BEGIN');
pl (' SELECT * INTO retval');
pl (' FROM ' || l_ltab);
pl (' WHERE ' || l_lcol || ' = ' || l_lcol || '_in;');
pl (' RETURN retval;');
pl ('EXCEPTION');
pl (' WHEN NO_DATA_FOUND THEN');
pl (' RETURN NULL;');
pl (' WHEN OTHERS THEN');
pl (' err.log;');
pl ('END ' || l_ltab || '_row_for;');
pl ('/');
END;
/

Tags:
0 Subscribe


1 Reply

+ 1
  jm50's Photo
Posted Nov 18 2010 11:10 PM

This is just a procedure or synonym declared some where in your database. It may well be a wrapper for DBMS_OUTPUT.PUT_LINE but you need to check in the database. The proc may be in another schema with an synonym so you will need to look around or ask a DBA. If you can access the view ALL_OBJECTS you should be able to find more data there. (It does appear to be short cut for PUT_LINE.)