大家看看这个function对不对
CREATE OR REPLACE FUNCTION f_getpramvaluenew (p_str IN VARCHAR2)
RETURN VARCHAR2
AS
v_return VARCHAR2 (2048);
BEGIN
IF INSTR (p_str, 'sid=') > 0
THEN
v_return := SUBSTR (p_str, INSTR (p_str, 'sid=') + 4);
END IF;
IF INSTR (v_return, '&') > 0
THEN
v_return := RTRIM (SUBSTR (v_return, 1, INSTR (v_return, '&') - 1));
END IF;
RETURN v_return;
EXCEPTION
WHEN OTHERS
THEN
RETURN 'error';
END;