Answer Posted / shaveta gulati

Ref Cursor:

ref cursor is a data structure which points to an object
which in turn points to the memory location.

ex:

create or replace procedure test()

as

begin

type ref_cursor is ref cursor;

open ref_cursor as

select * from table_name;

end;

There are 2 types in this.

1.strong ref cursor:

This has a return type defined.

2. weak ref cursor.

this doesnt have a return type

normal cursor:

Nothing but the named memory location.

it has 2 types

1. explicit cursor

Need to be defined whenever required.

2.Implicit cursor

need not defined and used by oracle implicitly in DML
operation.

In case of an normal explict cursor, the SQL query has to
be defined at the time of declaring the cursor itself. In
case of REF Cursor, the cursor declartion is not associated
with any SQL query, it is associated with a query at a
later stage this brings in a lot of flexibility as
different SQL queries can be associated with the cursor
(one at a time, offcourse) programatically. REF Cursors
also provide the feature of passing parameters. Though
there is something dynamic with REF Cursor when compared to
a normal explicit cursor, it is not a truly perfect dynamic
cursor. Truly perfect dynamic cursors are the one
constructed using DBMS_SQL package.

What are the different components of soa suite?

1153

---

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

2289

---

Is soa a part of oracle fusion middleware?

1051

---

How to move the one file from one instance to another instance? And your scripts also?

1077

---

Plz anybody send me Technical specification for AP Interface

2514

---

testing tools?

2192

---

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1035

---

Can you differentiate between mediator and osb?

1096

---

List the types of flexfield?

998

---

What are the benefits of using soa architecture?

1192

---

what are the different transaction clauses in AR?

2067

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2996

---

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

2377

---

In oracle application how do you debug or trace errors?

1066

---

Explain what are the tables of auto invoice?

1100

---