Saturday, October 21, 2017

Restrictions on cursor variables?

Restrictions on Cursor Variables:-

  1. Cursor variable can't use with dynamic sql.
  2. Cursor variable can't use with in package because it is not having persistent state.
  3. Nulls can't assigned to cursor variable.
  4. Remote procedure can't accept cursor variable

No comments:

Post a Comment

Query to get the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...