This content has been marked as final. Show 6 replies
what function are you using for this ?1 person found this helpful
iam declaring two variables EMPDATA and Query.In EMPDATA variable i am writing insert query using expression builder like 'insert into emp(empname,empno,dept) values ('rahul',101,'hr').
after that iam calling this variable in Query variable using query-database function:
Pls help me in this....
oraext:query-database can only be used for SELECT operations. So INSERT won't work.
Consider using DB Adapter or please share your use-case to help you further on this.
You might take a java embedded activity and within that you can make use of callable/prepared statement to insert data to database.
Thank you for reply,I want to insert data through query-database function .