1: PACKAGE BODY IEX_TERR_WINNERS_PUB AS
2: /* $Header: iexttwpb.pls 120.1 2005/12/06 07:43:18 lkkumar noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments
3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments
6: ---------------------------------------------------------------------------
7: -- PACKAGE NAME: IEX_TERR_WINNERS_PUB
8: -- ---------------------------------------------------------------------
9: -- PURPOSE
10: --
11: -- Public Package for the concurrent program
24:
25: /*-------------------------------------------------------------------------+
26: | PRIVATE CONSTANTS
27: +-------------------------------------------------------------------------*/
28: G_PKG_NAME CONSTANT VARCHAR2(30):='IEX_TERR_WINNERS_PUB';
29: G_FILE_NAME CONSTANT VARCHAR2(12):='asxttwpb.pls';
30:
31:
32: /*-------------------------------------------------------------------------+
110: DBMS_STATS.gather_table_stats(SCHEMA, TABLE_NAME, cascade=>TRUE, degree=>8, estimate_percent=>P_PERCENT);
111:
112: EXCEPTION
113: WHEN others THEN
114: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in Analyze_Table');
115: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
116: ' SQLERRM: ' || SQLERRM);
117: RAISE;
118: END Analyze_Table;
111:
112: EXCEPTION
113: WHEN others THEN
114: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in Analyze_Table');
115: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE: ' || to_char(SQLCODE) ||
116: ' SQLERRM: ' || SQLERRM);
117: RAISE;
118: END Analyze_Table;
119:
119:
120:
121:
122:
123: END IEX_TERR_WINNERS_PUB;