PL/SQL (MOSC)

MOSC Banner

Create trigger - build SQL statement and execute it

in PL/SQL (MOSC) 6 commentsAnswered ✓

I know I am likely over thinking this!

I want an on insert trigger on a table "employee". Also open to other options as well.

when a new record is inserted into the employee, I want to generate a script , and run it. This will create a user in our APEX system.

I can run it on the command line and manually execute it in a sql script no problem. Trying to automate it so I don't have to create a user each time a new user is onboarded.

Trying to figure out how to do the same thing but in a trigger - when a new record is inserted, build and execute the command.

Tagged:

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