PL/SQL (MOSC)

MOSC Banner

Need help with the error related to decode and returncode.

in PL/SQL (MOSC) 2 commentsAnswered

When I run the below query in 12c, it runs fine, but same gives error in 19c.

We recently migrated from 12c to 19c, so modified some tables to point to unified_audit_trail. Need to modify some scripts to enable auditing. Need help in modifying this to correct one so it can run in 19c DB.


select

 to_char(a.event_timestamp,'MM/DD/YY HH24:MI:SS')||', Action: '||

 action_name||' on '||DBUSERNAME||'.'||object_name||' by '||DBUSERNAME||' (OS_USER='||os_username||')'||' to '||grantee||

 decode(returncode,0,null,' - Failed') info

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