PL/SQL (MOSC)

MOSC Banner

Help With Trigger

edited Aug 1, 2014 5:01AM in PL/SQL (MOSC) 16 commentsAnswered

Pls I have a requirement for below.

AFTER UPDATE OR INSERT OR DELETE OF IS_DEFAULT_SCHEMA ON IC_SCHEMA_CONSUMER

  1. 1. Check whether the default schema is available for the consumer, if available
    1. a.       If the user is trying to update to a different schema as default, set the is_default_schema value to 2 for the current
    2. b.      If the user is trying to insert a new record with default schema value as 1, then set the is_default_schema value to 2 for the current , else nothing
    3. c.       If the user is trying to delete the record where is_default_schema value has been set to 1, throw the error.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center