I have a stored procedure that deletes items from a data table that are over 30 days old....
(create or replace
PROCEDURE PAGE_CLEANUP AS
-- delete entries in EMAILS_SENT that are older than 30 days.
DELETE FROM TRM_EMAILS_SENT
WHERE TIMESTAMP < SYSDATE - 30;
However, when I call the stored procedure from a method within my C# Webservice it doenst run the procedure. The unit test says that everything works fine but there are no rows deleted when I check the database.
Any help would be greatly appreciated.
public static void CleanUpPaging()
using (OracleConnection connection = new OracleConnection(ConnectionString))
OracleCommand command = new OracleCommand("PAGE_CLEANUP", connection);
command.CommandType = CommandType.StoredProcedure;