566: FUNCTION table_exists(p_table_name IN VARCHAR2) return BOOLEAN IS
567: l_count NUMBER;
568:
569: CURSOR cTables(pTableName IN VARCHAR2, pOwner IN VARCHAR2) IS
570: SELECT 1 FROM ALL_TABLES
571: WHERE TABLE_NAME = pTableName
572: AND OWNER = pOwner;
573: BEGIN
574: IF (g_initialized=false) THEN
602:
603: l_count NUMBER;
604:
605: CURSOR cTables(pTableName IN VARCHAR2, pOwner IN VARCHAR2) IS
606: SELECT 1 FROM ALL_TABLES
607: WHERE TABLE_NAME = pTableName
608: AND OWNER = pOwner
609: AND TEMPORARY = 'Y';
610: