Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Azure function hangs on 'Open' (ODP.net)

user8277306Apr 21 2021 — edited Apr 21 2021

I have the sample code below running in an azure function to test connectivity. The function hangs on the 'Open' method while MySQL and SQL server libraries run ok. The vnet is configured and no traffic hits the firewall which makes me think something is failing in the ODP code. No errors are thrown. Am I missing something?

I have tried 4.122.1.0 and 19.11.0 and both exhibit the same behavior

[FunctionName("SendReminders1")]
public static void SendReminders1([TimerTrigger("0 */1 * * * *")]TimerInfo myTimer, ILogger log) {
log.LogInformation("A");
using (OracleConnection Con = new OracleConnection("User Id=omitted;Password=omitted;data source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST = omitted)(PORT = 1521))(CONNECT_DATA=(SERVICE_NAME=omitted)));Max Pool Size=10")) {
log.LogInformation("B");
Con.Open();
log.LogInformation("C");
}
}

image.png

This post has been answered by Alex Keh-Oracle on Apr 21 2021
Jump to Answer
Comments
Post Details
Added on Apr 21 2021
4 comments
405 views