Form does not Raise Exception when Entering Wrong Password Using EXEC_SQL Package (Doc ID 3079211.1)

Last updated on MARCH 28, 2025

Applies to:

Symptoms

The application uses a custom login form in order to customize the login to the database. The custom login form captures the username, password and connection string and then passes the details to the EXEC_SQL package for connection to the database. 

The code contains an exception to throw an error if the user enters an invalid password:

EXCEPTION 
     WHEN EXEC_SQL.PACKAGE_ERROR ...

In Forms version 10G the exception was raised and the error was thrown. In Forms 12C the exception is not raised and the error is not thrown.

Changes

 Upgrade from Forms 10G to 12C

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.