can we write multiple procedures in package with same name
like A p1,p2(parameters)
B p1,p2(same parameters)

Answers were Sorted based on User's Feedback



can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(..

Answer / suresh

Yes this is what called "Procedure Overloading" Concept....

Might be all the given parameters be same, but the data
types will be different which produces different operations
as per defined in the procedure.

Is This Answer Correct ?    12 Yes 0 No

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(..

Answer / ranga reddy

Yes,This is called "Overloading"

We can use same names with different data types or
same names and same data types with different number of
parameters
(Ex:p1(3 parameters),p1(4 parameters))

Is This Answer Correct ?    6 Yes 2 No

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(..

Answer / devi nossam

yes,
we can write any number of procedures in one package
with the same name it is called as procedure overloading.
but those variables datatype must be different.

Is This Answer Correct ?    2 Yes 0 No

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(..

Answer / mahesh

in packages subprograms with same name
but the parameters are different data types
called 'SUBPROGRAM OVERLODING'

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Oracle Apps Technical Interview Questions

How to retry multiple errored workflow processes? What is the access level in workflow used for? How do you define start and end functions in workflow? How does they differ from normal functions? Give me some workflow tables? What is the difference between a function and notification in workflow? I have sent two different notifications to two different users and I want to wait till both they are approved to send 3rd notification. How can you achieve it? What is item type and item key in workflow? How do you use attribute values in workflow messages? How do you use lookups in workflow? What are roles in workflow and how they are used? How do you download or upload a workflow from a server? What are steps to customize the workflow? What functions can you perform from workflow administrator responsibility? To send an email to the user workflow notification is the only way or is there any other ways to send it? Give me some workflow standard procedures? How can you run/start/kickoff workflow? What is wf_engine package used for? How many processes can each workflow contain? What is Runnable option in workflow? At what level it exists? What are different types of attributes in workflow? How do you reassign a notification? What is process in workflow? How can you send direct oracle form link through workflow notifications? How can you send a notification to multiple users? Can you change the list dynamically? Can you send html code in workflow notification? I have sent two different notifications to two different users and I want to wait till atleast one is approved to send 3rd notification. How can you achieve it?

0 Answers   Accenture, CTS,


in GL module specifing org_id or not?

1 Answers  


in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,


What is secuirity's in R12 features.

1 Answers   KPIT,


hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,






what is tuning in oracle apps technical

3 Answers   TCS,


what is the use of format trigger?a

3 Answers  


Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,


HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,


How many typres of Purchase order and what are those.

2 Answers   Accenture,


PL/SQL stored procedure parameters?

7 Answers  


How to migrate .rdf file from dev instance to test instance?

3 Answers   Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)