Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

DB Connector error for disable query

sris
New Contributor III
New Contributor III

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.

If you find the above response useful, Kindly Mark it as "Accept As Solution".

rushikeshvartak
All-Star
All-Star

Can you share screenshot from database when it run successfully.


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.