Line 165: SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE='CZIMPORT';
161: FUNCTION SPX_IMPORTSESSIONS RETURN INTEGER IS
162: nRet INTEGER;
163: BEGIN
164: BEGIN 165: SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE='CZIMPORT'; 166: EXCEPTION
167: WHEN NO_DATA_FOUND THEN
168: nRet:=0;
169: END;
Line 200: SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE like 'CZ_SYNC%';
196: FUNCTION SPX_PUBLISHSESSIONS RETURN INTEGER IS
197: nRet INTEGER;
198: BEGIN
199: BEGIN 200: SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE like 'CZ_SYNC%'; 201: EXCEPTION
202: WHEN NO_DATA_FOUND THEN
203: nRet:=0;
204: END;