Re: Need Help with some PLSQL code please

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 13 Sep 2003 09:08:41 -0700
Message-ID: <1063469307.155833@yasure>

Comments interspersed:

Chris ( Val ) wrote:

><snipped>
>
>
>

I would suggest you rewrite in the following form:

CREATE OR REPLACE PROCEDURE FIND_DXF_ERRORS (....) IS CURSOR and EXCEPTION definitions ...

MyFlag BOOLEAN := FALSE;
Counter NUMBER( 5 ) := 0;

TempID VARCHAR2( 50 );
nTempID NUMBER(##);

TempDate VARCHAR2( 50 );
dTempDate DATE;

BEGIN
   BEGIN
      nTempID := TO_NUMBER(TempID);
   EXCEPTION

      WHEN OTHERS THEN
         RAISE ...

   END;    BEGIN
      dTempDate := TO_DATE(TempDate);
   EXCEPTION

      WHEN OTHERS THEN
         RAISE ...

   END;    ....

END;
/

Dump the functions and just deal directly with the problem at hand.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Sep 13 2003 - 11:08:41 CDT