430:
431: IF (p_dynamic_sql IS NOT NULL) THEN
432: IF ((p_dynamic_sql(1) IS NOT NULL) AND (p_dynamic_sql(2) IS NOT NULL)) THEN
433: BEGIN
434: cursor_name := dbms_sql.open_cursor;
435: dbms_sql.parse(cursor_name, p_dynamic_sql(1), dbms_sql.NATIVE);
436:
437: IF (p_dynamic_sql(2) = 'Y') THEN
438: dbms_sql.bind_variable(cursor_name, ':1', p_bind_value);
431: IF (p_dynamic_sql IS NOT NULL) THEN
432: IF ((p_dynamic_sql(1) IS NOT NULL) AND (p_dynamic_sql(2) IS NOT NULL)) THEN
433: BEGIN
434: cursor_name := dbms_sql.open_cursor;
435: dbms_sql.parse(cursor_name, p_dynamic_sql(1), dbms_sql.NATIVE);
436:
437: IF (p_dynamic_sql(2) = 'Y') THEN
438: dbms_sql.bind_variable(cursor_name, ':1', p_bind_value);
439: END IF; -- end of if: p_dynamic_sql(2) = 'Y'
434: cursor_name := dbms_sql.open_cursor;
435: dbms_sql.parse(cursor_name, p_dynamic_sql(1), dbms_sql.NATIVE);
436:
437: IF (p_dynamic_sql(2) = 'Y') THEN
438: dbms_sql.bind_variable(cursor_name, ':1', p_bind_value);
439: END IF; -- end of if: p_dynamic_sql(2) = 'Y'
440:
441: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
442: dbms_sql.close_cursor(cursor_name);
437: IF (p_dynamic_sql(2) = 'Y') THEN
438: dbms_sql.bind_variable(cursor_name, ':1', p_bind_value);
439: END IF; -- end of if: p_dynamic_sql(2) = 'Y'
440:
441: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
442: dbms_sql.close_cursor(cursor_name);
443: IF (rows_processed = 0) THEN
444: -- no rows found, thus it's not in use
445: l_Is_Exist := FALSE;
438: dbms_sql.bind_variable(cursor_name, ':1', p_bind_value);
439: END IF; -- end of if: p_dynamic_sql(2) = 'Y'
440:
441: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
442: dbms_sql.close_cursor(cursor_name);
443: IF (rows_processed = 0) THEN
444: -- no rows found, thus it's not in use
445: l_Is_Exist := FALSE;
446: END IF;
446: END IF;
447:
448: EXCEPTION
449: WHEN OTHERS THEN
450: dbms_sql.close_cursor(cursor_name);
451: END;
452:
453: END IF; -- end of if: p_dynamic_sql(1) IS NOT NULL
454: