1: PACKAGE BODY CSF_SPATIAL_TTSP_PUB AS
2: /* $Header: CSFPTTSPB.pls 120.1 2009/08/25 10:53:53 vpalle noship $ */
3:
4: /* This procedure is called from Spatial Dataset TTSP Plugin concurrent program.
5: It plugins the TTSP containg the spatial data with the help of DATAPUMP. It also imports
208: retcode := 1;
209:
210: errbuf := sqlerrm;
211:
212: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
213:
214: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
215: END DATAPUMP_EXPORT;
216:
210: errbuf := sqlerrm;
211:
212: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
213:
214: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.DATAPUMP_EXPORT PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
215: END DATAPUMP_EXPORT;
216:
217: PROCEDURE PREPARE_INDEXES_FOR_TTS(
218: p_table_space IN VARCHAR2,
233: retcode := 1;
234:
235: errbuf := sqlerrm;
236:
237: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
238:
239: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
240: END PREPARE_INDEXES_FOR_TTS;
241:
235: errbuf := sqlerrm;
236:
237: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
238:
239: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.PREPARE_INDEXES_FOR_TTS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
240: END PREPARE_INDEXES_FOR_TTS;
241:
242: /* DBMS_STATS.EXPORT_TABLE_STATS Procedure
243: ==================================
261: retcode := 1;
262:
263: errbuf := sqlerrm;
264:
265: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
266:
267: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
268: END EXPORT_TABLE_STATS;
269:
263: errbuf := sqlerrm;
264:
265: CSF_SPATIAL_TTSP_PVT.put_stream(g_output, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' ||SQLCODE||'-'|| SQLERRM);
266:
267: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
268: END EXPORT_TABLE_STATS;
269:
270:
271: END CSF_SPATIAL_TTSP_PUB;
267: CSF_SPATIAL_TTSP_PVT.put_stream(g_log, 'CSF_SPATIAL_TTSP_PUB.EXPORT_TABLE_STATS PROCEDURE HAS FAILED' || SQLCODE||'-'||SQLERRM);
268: END EXPORT_TABLE_STATS;
269:
270:
271: END CSF_SPATIAL_TTSP_PUB;
272: