We are using Novell for our network operating system and Oracle for our database. Currently, our Novell ID is also the Oracle login name. In the future, we will be changing our Novell IDs. These new Novell IDs will be kept in a table which also contains the Oracle login name.
My problem is that when the program logs in using a hardcoded name with rights, and a SQL statement is opened to get the Oracle login name, the program goes to the start of the procedure, and does not execute the statements after the Open statement which logins to the database using the correct name.
My problem is that when the program logs in using a hardcoded name with rights, and a SQL statement is opened to get the Oracle login name, the program goes to the start of the procedure, and does not execute the statements after the Open statement which logins to the database using the correct name.