[Home] [Help]
4372: BEGIN
4373:
4374: SELECT COUNT(object_name)
4375: INTO nb_nimm
4376: FROM sys.dba_objects
4377: WHERE object_name = table_name_nimm
4378: AND owner = l_user_schema;
4379:
4380: EXCEPTION
4386: BEGIN
4387:
4388: SELECT COUNT(object_name)
4389: INTO nb_imm
4390: FROM sys.dba_objects
4391: WHERE object_name = table_name_imm
4392: AND owner = l_user_schema;
4393:
4394: EXCEPTION
4400: BEGIN
4401:
4402: SELECT COUNT(object_name)
4403: INTO nb_aimm
4404: FROM sys.dba_objects
4405: WHERE object_name = table_name_aimm
4406: AND owner = l_user_schema;
4407:
4408: EXCEPTION
4541: BEGIN
4542:
4543: SELECT COUNT(object_name)
4544: INTO nb_obj
4545: FROM sys.dba_objects
4546: WHERE object_name = g_tmp_table_nimm
4547: AND owner = l_user_schema;
4548:
4549: EXCEPTION
4569: BEGIN
4570:
4571: SELECT COUNT(object_name)
4572: INTO nb_obj
4573: FROM sys.dba_objects
4574: WHERE object_name = g_tmp_table_imm
4575: AND owner = l_user_schema;
4576:
4577: EXCEPTION
4592: BEGIN
4593:
4594: SELECT COUNT(object_name)
4595: INTO nb_obj
4596: FROM sys.dba_objects
4597: WHERE object_name = g_tmp_table_aimm
4598: AND owner = l_user_schema;
4599:
4600: EXCEPTION