Trace files of large sizes are getting generated

Hello DBA's,

Good Afternoon!!

Hope Every one is doing a great job.
I have a issue in one of my database, Where in I see trace files of 4mb's
are getting generated but previous to that it was not like that the size it
used to be of 3kb.
Due to this the database got hunged and we need to reboot and delete the
contents of dump directories.
I could see in the trace files as


ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified:
ORA-22275

ORA-22288: file or LOB operation FILEOPEN failed

Permission denied

Current SQL statement for this session:

DECLARE

iCount NUMBER :=1;

Status VARCHAR2(4);

BEGIN

DB.stp_snr_ne_load_xml('NE_CMPNY_STORY_LINK_ST','200910240444NYT_____NEWS__

___387932_1490.3.xml','NEWSEDGEISSUE.xsl','NEWSEDGE_XML_SOURCE_DIR','NEWSEDGE_XS

L_SOURCE_DIR');

COMMIT;

EXCEPTION

WHEN OTHERS

THEN

PKG_DEBUG.stp_SetDebugState(TRUE, FALSE, TRUE);

PKG_DEBUG.STP_OUTPUT ('Loading of File Story Cmpny Relation failed');

RAISE;

END;

Your help will be highly appreciated.

Thanks

Nilesh

Other related posts: