|
|
|||
utility of pl word in use of pl/sql
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; / 1 Reply
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.)
|
|||
|