Re: Oracle Reports - Help please!!!

From: <hopeli_at_my-dejanews.com>
Date: Tue, 14 Jul 1998 19:27:06 GMT
Message-ID: <6ogbea$hv1$1@nnrp1.dejanews.com>

Stan,
 I was receiving this message in a similar situation (launching four reports from Forms). I asked a co-worker Dolores, if she had the same experience. She did, and gave me her solution.

Create a form level trigger such as this:

DECLARE

   lv_errcod  NUMBER       := ERROR_CODE;
   lv_errtyp  VARCHAR2(3)  := ERROR_TYPE;
   lv_errtxt  VARCHAR2(80) := ERROR_TEXT;

BEGIN   IF (lv_errcod = 41211) THEN

           Null;

  ELSE
   Message(lv_errtyp||'-'||to_char(lv_errcod)||': '||lv_errtxt);

      RAISE Form_Trigger_Failure;
END IF;
END; I tried this code, and I no longer receive the FRM-41211 message. Hope this helps.

 In article <scs.14.3593B1AD_at_ornl.gov>,   scs_at_ornl.gov (Stan Stines) wrote:
>
> Has anyone seen this error:
>
> "FRM-41211 SSL intergration error"
>
> We are converting from 16 bit to 32 bit using Dev 1.6. My problem is that
> when a 4.5 Form calls (RUNPRODUCT) more than one report running "ASYNCHRONOUS"
> I get a "FRM 41211 SSL intergration error". The reports still run but I get
> the error.
>
> This code gives the error 3 times:
>
> RUN_PRODUCT(REPORTS,'HPX15SS.REP',ASYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
> RUN_PRODUCT(REPORTS,'HPX15D.REP',ASYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
>

RUN_PRODUCT(REPORTS,'HPX15DPT.REP',ASYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
>
> This code will give the error after the first report runs with no errors:
>
> RUN_PRODUCT(REPORTS,'HPX15SS.REP',SYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
> RUN_PRODUCT(REPORTS,'HPX15D.REP',ASYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
>

RUN_PRODUCT(REPORTS,'HPX15DPT.REP',ASYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
>
> This code will give NO errors:
>
> RUN_PRODUCT(REPORTS,'HPX15SS.REP',SYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
> RUN_PRODUCT(REPORTS,'HPX15D.REP',ASYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
>
> This code will give NO errors:
>
> RUN_PRODUCT(REPORTS,'HPX15SS.REP',ASYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
>
> Stan
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 14 1998 - 14:27:06 CDT