Convert to Oracle Wallet

Validation of Existing Setup

Check Current Setup

SELECT * FROM "BANSECR"."GURUOBJ" WHERE GURUOBJ_OBJECT=:JOB AND GURUOBJ_USERID='BAN_APPWORX_JOBS_C'; --:JOB=JOBNAME

SELECT * FROM "BANSECR"."GURAOBJ" WHERE GURAOBJ_OBJECT=:JOB AND GURAOBJ_CURRENT_VERSION =:VERS;--:JOB=JOBNAME and :VERS=1.0

Setup Needs Maintenance

If both queries in Check Current Setup each return a record, then no further action needed other than substituting wallet code for ID/PW.

If one does not return a result, an insert is required to the respective BANSECR table.

Work with UC4 Admin to Troubleshoot

 

100% helpful - 1 review