47: n NUMBER;
48:
49: BEGIN
50:
51: cur_hdl := dbms_sql.open_cursor;
52: dbms_sql.parse(cur_hdl, m_array, 1, m_idx, false, dbms_sql.native);
53: n := dbms_sql.execute(cur_hdl);
54:
55: BEGIN
48:
49: BEGIN
50:
51: cur_hdl := dbms_sql.open_cursor;
52: dbms_sql.parse(cur_hdl, m_array, 1, m_idx, false, dbms_sql.native);
53: n := dbms_sql.execute(cur_hdl);
54:
55: BEGIN
56: SELECT STATUS INTO l_status FROM USER_OBJECTS
49: BEGIN
50:
51: cur_hdl := dbms_sql.open_cursor;
52: dbms_sql.parse(cur_hdl, m_array, 1, m_idx, false, dbms_sql.native);
53: n := dbms_sql.execute(cur_hdl);
54:
55: BEGIN
56: SELECT STATUS INTO l_status FROM USER_OBJECTS
57: WHERE OBJECT_NAME = m_name