Guys
i have a function like thiscreate or replace FUNCTION insBRAND_DATA(
p_BRAND_DATA_ID OUT BRAND_DATA.BRAND_DATA_ID%TYPE,
p_CONTENT_TYPE IN BRAND_DATA.CONTENT_TYPE%TYPE,
p_CONTENT_SZ IN BRAND_DATA.CONTENT_SZ%TYPE,
p_DATA_TYPE IN BRAND_DATA_TYPE.DATA_TYPE%TYPE,
p_DESCRIPTION IN BRAND_DATA.DESCRIPTION%TYPE,
p_AUDIT_BRAND_ID IN BRAND_INFO.BRAND_ID%TYPE,
p_AUDIT_USER_ID IN USERS.USER_ID%TYPE
)RETURN INTEGER IS
BEGIN
INSERT INTO BRAND_DATA
( DATA_TYPE,
BRAND_ID,
BRAND_DATA_ID,
CONTENT_SZ,
CONTENT_TYPE,
DESCRIPTION,
LAST_MODIFIED
) VALUES (
p_DATA_TYPE,
p_AUDIT_BRAND_ID,
SEQ_BRAND_DATA_ID.NEXTVAL,
p_CONTENT_SZ,
p_CONTENT_TYPE,
p_DESCRIPTION,
SYSDATE
);
SELECT BRAND_DATA_ID into p_brand_data_id FROM BRAND_DATA
WHERE BRAND_DATA_ID = SEQ_BRAND_DATA_ID.CURRVAL;
RETURN 0;
EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN
--record did not insert, key already exists
RETURN -2;
WHEN OTHERS THEN
--record did not insert, unknown error
RETURN -1;
END insBRAND_DATA;

and when i execute this i get discoonectted to db by error 03113.all other functions works fine,but only this..could u pls let me know if there is any problem in this fun.
thx