Hi,
We want to create an account via the DB connector. The database table is column-oriented so to create one account we need to insert multiple rows into the table.
{
"CreateAccountQry":"INSERT ALL
INTO tablename(col1,col2,col3,col4) VALUES ('Username',${user.employeeid},${user.username},SYSDATE)
INTO tablename(col1,col2,col3,col4) VALUES ('firstname',${user.employeeid},${user.firstname},SYSDATE)
INTO tablename(col1,col2,col3,col4) VALUES ('lastname',${user.employeeid},${user.lastname},SYSDATE)
INTO tablename(col1,col2,col3,col4) VALUES ('employeeid',${user.employeeid},${user.employeeid},SYSDATE)
SELECT * FROM dual"
}
Here in the database table, the Saviynt user column name is stored in column 1 of the target application, and values are stored in column 3 of the target application. Column2 contains a constant value to refer to the account.
While using above query we are getting attached error in the logs
If anyone worked on similar kind of requirement., please provide us a valid JSON format to create account in oracle Database.
Best Regards,
Aditya Chadde
