On A server, set up in oracle user A, B, B generated method for A data into and finishing clear, therefore, both user table structure and the archive process exactly, now, occasional front-end is clearly connected users A, is called the user B stored procedure, to solve,

CodePudding user response:

No, it is recommended that you let developers check program configuration,

Is called a stored procedure, you can add some log, the current user to a table,

Select the user from dual

CodePudding user response:

Eighty percent is not project configuration

CodePudding user response:

This and the oracle database itself has nothing to do,

CodePudding user response:

Should be your application configuration file out the problem, check the configuration file
1. The version of the problem?
2. You can try to print some database connection logs, debug debugging information, such as

CodePudding user response:

Reminded of a joke, two days before a certain branch operations told production table space is not enough, the data into times wrong ORA - 01654, and the data files are useless, check for a long time didn't find the reason, also ask what this is met senior mistake, besides there is insufficient space on the table what other weird, or is a BUG? As a skeptical colleagues all don't believe in yourself even DBA, tell them, are you the wrong library. Soon there will be news, even the wrong library application, to test library, table space and production environment, in order to insert the tens of thousands of data, with 20 g space,

CodePudding user response:

Several days didn't come, I think maybe you understand is wrong, or I didn't say understand?
I was found in the development environment to track, for example, the data submitted to A user's table, and then calls A user stored procedures for subsequent processing, only to find that the stored procedure was invoked the user B stored procedures with the same name, I also lost the eyeball, the MEssage the username, indeed as A user, dizzy,

CodePudding user response:

More surprisingly, the error case, without any processing program code, users, PLSQL connection A compilation of the stored procedure, in which the normal,