09/14/2023 05:28 AM
Hi,
We are using a storedproc to disable the DB account via DB connector. THe storedproc has IN/OUT parameter. Below is the query
{"disableaccountqry":"call SP('${accountName}',0)"}
Second param is the IN/OUT parameter. Any idea how we can call it from saviynt to get the expected result of disabling the account?
Below is the error
Error while Executing Disable query - ORA-06577: output parameter not a bind variable"
Thanks,
Sri
09/16/2023 10:30 PM
Hello @sris ,
The error message “ORA-06577: output parameter not a bind variable” suggests that the way you are trying to pass the IN/OUT parameter to your stored procedure in Oracle Database is causing an issue. In Oracle, OUT or IN/OUT parameters need to be declared as bind variables when calling stored procedures.
could you please share your whole query.
Thanks.
09/17/2023 06:56 PM
Can you share screenshot from database when it run successfully.