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 Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...