Answer Posted / 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;

In support project one ticket alloted which steps follows manualy tell me ?

2611

---

how can i print random rows in plsql table

2415

---

What are do's and dont's of Interface?

2369

---

Explain what are the tables of auto invoice?

1096

---

do you know is it possible to run the interface without using oracle apps?

1065

---

Plz anybody send me Technical specification for AP Interface

2504

---

What do you understand by a set of books?

1043

---

Can you differentiate between mediator and osb?

1091

---

tell me the scenarios of the independent in reports

2564

---

How to create a purchase order without a requisition?

1125

---

what is the difference between request group and request security in oracle apps?

5791

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2211

---

Are you familiar with internet architecture of oracle apps 11i?

1015

---

Can we create tables in apps schema?

1083

---

What is sca and how is it useful?

1049

---