The following lines contain the word 'select', 'insert', 'update' or 'delete':
select oracle_username into l_schema_owner from fnd_oracle_userid where read_only_flag = 'U';
select count(*) into l_dblink_count from iem_db_connections where db_username=p_db_username and db_server_id=p_db_server_id;
select * INTO l_iem_server_rec from IEM_DB_SERVERS where DB_SERVER_ID = p_db_server_id;
select CONCAT(l_iem_server_rec.service_name, '@appsto_oo') into l_glname from DUAL;
select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_string);
select CONCAT(l_iem_server_rec.service_name, '@appsto_ora') into l_glname from DUAL;
select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_string);
l_statement := 'SELECT global_name FROM global_name@'||l_glname;
select count(*) into l_count from iem_db_connections where UPPER(db_link) = UPPER(l_glname) and db_server_id = p_db_server_id;
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
PROCEDURE delete_link (p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_db_connection_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
TYPE LinkCur Is REF CURSOR;
l_api_name VARCHAR2(255):='delete_link';
select * INTO l_iem_dbconn_rec from IEM_DB_CONNECTIONS where DB_CONNECTION_ID = p_db_connection_id;
SAVEPOINT delete_link_pvt;
IEM_DB_CONNECTIONS_PVT.delete_item(
p_api_version_number => 1.0,
p_db_conn_id => p_db_connection_id,
x_msg_count => x_msg_count,
x_return_status => x_return_status,
x_msg_data => x_msg_data);
IEM_DB_CONNECTIONS_PVT.delete_item(
p_api_version_number => 1.0,
p_db_conn_id => p_db_connection_id,
x_msg_count => x_msg_count,
x_return_status => x_return_status,
x_msg_data => x_msg_data);
ROLLBACK TO delete_link_pvt;
ROLLBACK TO delete_link_pvt;
--ROLLBACK TO delete_link_pvt;
END delete_link;