unable to execute procedure mc_analyze_assignments

[devaprakash_b]

Dear Experts,

we are using sap idm 8.0 SP00 and oracle database 12c. For few users we see roles in 512 and 1536 status. hence we would like to analyse why it is in these status by executing the below procedure, where 12345 is user mskey.

exec mc_analyze_assignments 12345;

when executing the above statement receiving error as invalid sql statement.

can you kindly let me know how to execute this procedure. when checked in the db level, this procedure has 1 in parameter and 3 out parameter.

We are using toad eclipse plugin to run queries.

Regards,

DP

[Steffi_Warnecke · Accepted solution]

Hello DP,

I always execute stored procedures via the Oracle SQL Developer or the MS SQL Management studio logged in as the OPER-user.

.

Also it could be an issue with your version. Isn't SP00 the very buggy service pack that SAP says not to use? I would really advice to update to at least SP03. I remember a lot of bugs and missing features when I had training on SP00.

.

Regards,

Steffi.

[devaprakash_b · Accepted solution]

Hi Steffi,

I have logged in with oper user and in eclipse we installed the toad plugin and from there we execute the sql related queries. bt unable to run this procedure.

yes sap mentioned SP00 is having bugs, and we are in process of upgrading it to SP04.

Regards,

DP

[Steffi_Warnecke · Accepted solution]

It will be hard to check for this error ("invalid sql statement"), if you can't access the stored procedure directly. Do you have access to the oracle SQL developer to check this way? Since you already have access to the OPER credentials this should be a small step. There you can check the procedure and its source code directly. And you wrote "

when checked in the db level", so you already have access to the procedure directly? What happens if you start it from there?

.

Regards,

Steffi.