Is there any way i can perform Delete(DML) operation using open reports Query Reports?
Tried creating the following function and calling it in an anonymous block, doesn't work. The function is given below
CREATE OR REPLACE
function Delete_func(idParam IN number)
FROM format_table formattr
if SQL%FOUND then
I have found that JapserServer does a transaction rollback after the query. If you are using msSQL, add
IF @@TRANCOUNT > 0 COMMIT TRANSACTION
before exiting Stored Procedure
I am able to execute DML queries but in return it expects some data to be returned. So we tried to write DML queries in an Function so that it could return data always. But through open reports, I am not able to invoke function written using Pl/SQl query.
thanks in advance for the help.
you can call function in ordinary SQL request.
For example (Oracle): select Delete_func(123) from dual;
For other RDBMS you could check the syntax of calling a function. Just remember that calling a procedure is different thing.
I used a function which is executing procedures in its body .