DB Connector error for disable query

sris
New Contributor
New Contributor

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

 

2 REPLIES 2

sudeshjaiswal
Saviynt Employee
Saviynt Employee

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.

rushikeshvartak
All-Star
All-Star

Can you share screenshot from database when it run successfully.