I need help with a quick perl job to parse weblogic logs and log4j log files. Here is some examples of the logs. The problem I am having is when an error shows up a java dump happens and add carriage returns and I need for those to concatenate to a single line.

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQL ExceptionTranslator.java:292) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:952) at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:985) at org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:117) at org.cmp.bgi.dp.impl.AuthorizationdpImpl$SecurityProcedure.execute(AuthorizationdpImpl.jav a:125) at org.cmp.bgi.dp.impl.AuthorizationdpImpl.updateUserPlans(AuthorizationdpImpl.java:80) at org.cmp.bgi.service.impl.AuthorizationServiceImpl.updateUserPlans(AuthorizationServiceImpl.j ava:104) at org.cmp.bgi.business.delegate.bgiDelegateImpl.updateUserPlans(bgiDelegateImpl.java:216) at org.cmp.bgi.util.bgiUtil.LoginUserIntoObiee(bgiUtil.java:933) at org.cmp.bgi.web.actions.QuickReportsAction.execute(QuickReportsAction.java:104) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java :226) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42) at org.cmp.j2eeinfra.uiframework.webapp.UIInstitutionalFilter.doFilter(UIInstitutionalFilter.ja va:227) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42) at org.cmp.infra.security.SecurityFilter.processSSORequest(SecurityFilter.java:821) at org.cmp.infra.security.SecurityFilter.doFilter(SecurityFilter.java:241) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletConte xt.java:3393) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(Unknown Source) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200) at weblogic.work.ExecuteThread.run(ExecuteThread.java:172) Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("bgi"."IR_SEC_USER_ROLE"."ROLE_ID" ) ORA-01403: no data found ORA-06512: at "bgi.PKG_SECURITY", line 389 ORA-06512: at line 1