Correct Way to Execute a Stored Procedure Using native.identity in Low-Code JDBC Provisioning (ISC)

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi All,

I’m using ISC with the JDBC connector and trying to call a stored procedure during single-account aggregation, using native.identity as the input parameter.

I reviewed the documentation on Account Query Settings (aggregation context)—specifically the single-account settings here—but it doesn’t mention how to pass input parameters into the stored procedure:
Account Query Settings – JDBC aggregation

The provisioning docs do show examples using $plan.nativeIdentity$—like with inserts or stored procedures—but that’s within provisioning operations, not aggregation:
Create Account – JDBC provisioning

So far, I’ve tried:

CALL STORED_PROCEDURE_NAME($plan.nativeIdentity.string)

…but it hasn’t worked.

Could anyone share the correct syntax for using native.identity in a stored procedure call during single-account aggregation?

Thank you!

2

Could you try this?
{ call stored_procedure(‘$(identity)’) }

3

Still getting the same generic error when trying to aggregate an account: “Error! The account could not be aggregated. Try again.”

4

We were able to successfully retrieve the account using the following syntax:
CALL STORED_PROCEDURE_NAME($plan.nativeIdentity$)

If you’re still encountering errors, it’s worth checking the account schema to verify what value is being used for the account ID or name. There might be a mismatch or unexpected format causing the issue.