I write a procedure for a logic, and another person writes a same procedure for the same logic from another machine. which will taken by the oracle server. both have the same names also?
Printable View
I write a procedure for a logic, and another person writes a same procedure for the same logic from another machine. which will taken by the oracle server. both have the same names also?
create or replace procedure is used then old procedure will be replace with last created procedure(in case same name is used).If u run
exec procedure_name then last created procedure(if no errors) is executed.
if u use 'create procedure' command u can not create more than one procedue with same name..
if the second person is creating the procedure using CREATE OR REPLACE it will be replaced with 1st procedure. so second person's procedure will take.
If the name is same it is not two but one procedure.
if you and the other user belongs to different schemas then two copy of same procedure will be created in two different schemas
acoording to the selection of tablespace. Procedure willbe taken by server.
[QUOTE=expertsharingdotcom;25767]if you and the other user belongs to different schemas then two copy of same procedure will be created in two different schemas[/QUOTE]
If that is the case they why this question.
Different schemas and different procedures. You need to pass the procedure name qualified by schema name to call that ,if u have the required previleges.