The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DB_SERVER_ID,EMAIL_USER,DOMAIN,EMAIL_PASSWORD
INTO l_db_server_id,l_user,l_domain,l_pass
FROM IEM_EMAIL_ACCOUNTS
WHERE EMAIL_ACCOUNT_ID=p_email_account_id;
IEM_DB_CONNECTIONS_PVT.select_item(
p_api_version_number =>1.0,
p_db_server_id =>l_db_server_id,
p_is_admin =>'P',
x_db_link=>l_im_link1,
x_return_status =>l_stat,
x_msg_count => l_count,
x_msg_data => l_data);
SELECT DB_SERVER_ID,EMAIL_USER,DOMAIN,EMAIL_PASSWORD
INTO l_db_server_id,l_user,l_domain,l_pass
FROM IEM_EMAIL_ACCOUNTS
WHERE EMAIL_ACCOUNT_ID=p_email_account_id;
IEM_DB_CONNECTIONS_PVT.select_item(
p_api_version_number =>1.0,
p_db_server_id =>l_db_server_id,
p_is_admin =>'P',
x_db_link=>l_im_link1,
x_return_status =>l_stat,
x_msg_count => l_count,
x_msg_data => l_data);