Answer Posted / jyothsna

cursor variables are subject to the following
restrictions:You cannot declare cursor variables in a
package spec. For example, the following declaration is not
allowed:CREATE PACKAGE emp_stuff AS TYPE EmpCurTyp IS REF
CURSOR RETURN emp%ROWTYPE; emp_cv EmpCurTyp; -- not
allowedEND emp_stuff;You cannot pass cursor variables to a
procedure that is called through a database link.If you
pass a host cursor variable to PL/SQL, you cannot fetch
from it on the server side unless you also open it there on
the same server call.You cannot use comparison operators to
test cursor variables for equality, inequality, or
nullity.You cannot assign nulls to a cursor
variable.Database columns cannot store the values of cursor
variables. There is no equivalent type to use in a CREATE
TABLE statement.You cannot store cursor variables in an
associative array, nested table, or varray.Cursors and
cursor variables are not interoperable; that is, you cannot
use one where the other is expected. For example, you
cannot reference a cursor variable in a cursor FORloop

What is pl sql record in oracle?

1037

---

what is heap table? : Sql dba

1108

---

what is uncommittable transactions? : Transact sql

996

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

960

---

What are the types of variables use in pl sql?

1044

---

Can we use distinct and group by together?

1057

---

what are ddl statements in mysql? : Sql dba

1201

---

What is t sql used for?

1016

---

Which kind of parameters cannot have a default value in pl sql?

1149

---

Which sql statement is used to return only different values?

1008

---

Which operator is used in query for pattern matching?

1089

---

How do I create a memory optimized filegroup?

968

---

what are the advantages of sql ? : Sql dba

1060

---

what are the differences between require and include, include_once and require_once? : Sql dba

1027

---

Is mariadb a nosql database?

1055

---