Interested to Buy Any Domain ? << Click Here >> for more details...
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
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
what is an index? : Sql dba
What is output spooling in sql*plus?
Can a table have no primary key?
What are triggers and its uses?
what is column? : Sql dba
How many types of triggers exist in pl/sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
Is mariadb nosql?
How can a function retun more than one value in oracle with proper example?
What do you mean by stored procedures? How do we use it?
What are hotfixes and patches?
How to load data with sql*loader?
What is schema in sql example?
What are dml commands?
What do we need to check in database testing?
