Index: openacs-4/packages/intermedia-driver/sql/oracle/search-packages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/intermedia-driver/sql/oracle/Attic/search-packages-create.sql,v diff -u -N -r1.1 -r1.1.2.1 --- openacs-4/packages/intermedia-driver/sql/oracle/search-packages-create.sql 27 Jan 2006 16:03:57 -0000 1.1 +++ openacs-4/packages/intermedia-driver/sql/oracle/search-packages-create.sql 16 Apr 2008 13:00:18 -0000 1.1.2.1 @@ -26,57 +26,6 @@ -- The site_wide_search packages holds generally useful -- PL/SQL procedures and functions. -create or replace package search_observer -as - procedure enqueue ( - object_id acs_objects.object_id%TYPE, - event search_observer_queue.event%TYPE -); - procedure dequeue ( - object_id acs_objects.object_id%TYPE, event - search_observer_queue.event%TYPE, event_date - search_observer_queue.event_date%TYPE -); -end search_observer; -/ -show errors - -create or replace package body search_observer -as - procedure enqueue ( - object_id acs_objects.object_id%TYPE, - event search_observer_queue.event%TYPE -) is -begin - insert into search_observer_queue ( - object_id, - event - ) values ( - enqueue.object_id, - enqueue.event - ); - - end enqueue; - - procedure dequeue ( - object_id acs_objects.object_id%TYPE, - event search_observer_queue.event%TYPE, - event_date search_observer_queue.event_date%TYPE -) is - begin - - - delete from search_observer_queue - where object_id = dequeue.object_id - and event = dequeue.event - and to_char(dequeue.event_date,'yyyy-mm-dd hh24:mi:ss') = to_char(dequeue.event_date,'yyyy-mm-dd hh24:mi:ss'); - - end dequeue; -end search_observer; -/ -show errors - - create or replace package site_wide_search as procedure register_event (p_object_id search_observer_queue.object_id%TYPE,