Credentials - Oracle
Dear CPS developers
I am new to this forum and new to version 7 and I am struggling with credentials - especially with Oracle credentials. What needs to match where information wise that such a credential would work? How could a test credentials efficiently.
I am trying to set up a small test with a cronacle script that looks like that:
create or replace script "xxx"."xxx_S_ADMIN_REMOTE_SQL"
( "JCS_RUNUSER" in varchar2(30) null
description 'Use this credentials for the JCS_RUNDB job'
nocmdfile
default expr('<db_user>' )
, "JCS_RUNDB" in varchar2(64) null
description 'Perform job in database'
nocmdfile
default expr('db_name' )
)
application "SYSJCS"."xxx"
format "SYSJCS"."GENERIC"
queue "SYSJCS"."xxx"
no verify
as declare
lv_sysdate varchar2(10);
begin
select to_char(sysdate, 'dd-mm-yyyy') into lv_sysdate from dual;
dbms_output.put_line('ln_sysdate: '||lv_sysdate);
end;
/
and a credential that looks like that:
create or replace credential "SYSJCS"."ORACLE"."<db_name>"."<db_user>"
encoded password ''
/
Somehow I always get this error:
ORA-20800: JCS-02370: SYSJCS has no access to ORACLE credentials for <db_user> on system <db_name>
ORA-06512: at "SYSJCS.DDL", line 7556
ORA-06512: at line 3
JCS-00215: in statement RSO_GET_PASSWORD
I tried different versions and it doesn't work.
Many thanks for your support & regards
Stephan