Answer / amit shrivastava

Stored Procedure store in the database as a independent
obejct and can call directly with proc name.

begin
proc_ex (e_name,e_no);
end;

Answer / saleem

Stored procedure is a sequence of statements that perform
specific function.

Answer / kranthi

A stored Procedure is the one which is stored in the
database in a compiled format.Can be used directly as it is
in compiled format.

Answer / sannidhi84

it is a set of sql statements ...where all dml operations
can be done and dql operations as welll...it is stored in
database as compiled format.

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,

---

What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,

---

Hoe to skip middle of the record by using SQL*Loader?

5 Answers  

---

what is pay run id ?

0 Answers  

---

what are the pl/sql tables

1 Answers   IBM,

---

---

what is the use of format trigger?a

3 Answers  

---

Explain oracle apps architecture.

0 Answers  

---

Can functions be overloaded ?

2 Answers  

---

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,

---

Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,

---

tell my any difficult situtation you solved in your experience in your company?

0 Answers   Accenture,

---

What is cursor?

3 Answers  

---