Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLSQL - Cannot execute DML inside a query....

446714Jun 22 2006 — edited Jun 23 2006
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2006
Added on Jun 22 2006
10 comments
1,505 views