PACKAGE BODY: APPS.FND_OAM_EXPLAIN_PLAN

Source

1 PACKAGE BODY FND_OAM_EXPLAIN_PLAN as
2 /* $Header: oamexplb.pls 120.0 2010/05/19 17:51:08 tshort noship $ */
3 PROCEDURE GEN_EXP_PLAN(p_statement_id IN NUMBER,
4                       p_sql_stmt IN VARCHAR2)
5 IS
6 	sql_stmt varchar2(32767);
7 BEGIN
8 	sql_stmt := 'explain plan set statement_id = ''' || p_statement_id;
9 	sql_stmt := sql_stmt || ''' into plan_table for ';
10 	sql_stmt := sql_stmt || p_sql_stmt;
11 	execute immediate sql_stmt;
12 END;
13 END FND_OAM_EXPLAIN_PLAN;