Details: A User has submitted a Concurrent program request from XXX responsibility later when other user wants to see the same concurrent program request submitted by the earlier user. But, he unable to see the request in the same responsibility (Querying with Request Id in SRS view request screen)
Reason: When User submits the concurrent program from "others-->request --> run” screen others cannot see the concurrent request when they are in the same responsibility with the same request id
If user submits the concurrent program from SRS (STATDARD REQUEST SUBMISSION) window then we can see the request with out any issues.
If user submits the concurrent program from Request --> Run in the Menu of responsibility then others cannot able to view the concurrent program request even though they are in the same responsibility.
Overloading concept in Oracle PL/SQL
Overloading concept means, it allows you to overload procedures or functions in package with same name but different in data type and order of the parameters. When you call an over load subprogram, compiler determines which subprogram to call based on the data type which used in subprograms.
Single sub programs cannot be overloaded.
create or replace package testpack
Procedure test1(p_num NUMBER, p_name VARCHAR2);
Procedure test1(p_num NUMBER, p_name VARCHAR2,p_num2 NUMBER);
create or replace package body testpack
Procedure test1(p_num NUMBER, p_name VARCHAR2)
Procedure test1(p_num NUMBER, p_name VARCHAR2,p_num2 NUMBER)