Answer / kiran kumar

---- is a named pl/sql block to perform a specific task.
---- A procedure may have DML statements.
---- It may or may not return a value.
---- Procedure can return more than one value.

Example for procedure
1)To accept the year as a parameter and list emp belong to
the year?
Create or replace
Procedure empy(y number) is
Cursor emp_cursor is
Select * from emp where to_char(hiredate,?yyyy?)=?y?;
Emp_record emp%rowtype;
Begin
For emp_record in emp_cursor loop
Print (emp_record.empno);
Print (emp_record.ename);
Print (emp_record.sal);
End loop;
End;
Output :
var empx number;
Begin
:empx := ?1234?;
End;
Exec empy(:empx);
Print empy;

Answer / nidhi

Procedure consist of set of the PL/SQL statments that are
grouped togather as a unit to solve a specific problem or
perform set of related tasks.
-->May or may not return the value.
-->can not use in teh sql queries because returns more than
one value.

Answer / chandrasekhar

procedure is subprogram in pl/sql that contains a set of
SQL and PL/SQL statements.Subprograms once we executed can
be used in any no.of applications

In custom.pll what are the events we can Not write.

1 Answers  

---

What is the difference between base table and multi-org table?

3 Answers   Infosys,

---

In interface how u find errors and how to solve. How to fix it?

3 Answers  

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

What is a flexfield? List out its types.

0 Answers  

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

How we print the multi language in report?can any one give me step bye step explanation.

2 Answers   HCL, IBM, Tech Mahindra,

---

tell me the scenarios of the independent in reports

0 Answers   TCS, Wipro,

---

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers   Wipro,

---

what are the tables of auto invoice.

2 Answers  

---

what is difference between po_headers_all and po_headers

2 Answers   NTT Data,

---

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,

---