PLSQL - Cannot execute DML inside a query....
446714Jun 22 2006 — edited Jun 23 2006Hi,
I have written a PLSQL function that is part of a package which among other things needs to insert some data into some tables. When I test it standalone it is fine, however dozens of vbscript ASP applications call the function using a select statement:
sql = "Select package_name.function_name from dual"
conn.execute(sql)
Now when I try and log in to any of the applications oracle is complaining that I am not allowed to execute DML inside a query. This is ridiculous and I can't see any way around it. I'm hoping for a solution on the oracle side of things, because if the only solution is in ASP then I'm going to have the awful task of changing dozens of files.
I hope someone can help
Adam