parameter passing in the weak cursor

From: Dacho <dtho65_at_yahoo.com>
Date: 22 Mar 2004 13:17:12 -0800
Message-ID: <384dc9a9.0403221317.37996255@posting.google.com>

Hi All,

   Could someone light me up please?

   I used either straight select statement or parameter passing's statement I've still got the error as

     PLS-00103: Encountered the symbole "End-of-file" when expecting one of the following: begin function package pragma procedure form external.

    while perform compiling the following procedure with oracle 8.0.6.1.

CREATE OR REPLACE PROCEDURE Srch_Tbl (Tbl IN varchar2, Col IN varchar2, Ddate IN DATE) IS

   Type cRef IS REF CURSOR;    

   cTbl           cRef;
   pos            integer;


/*   string         varchar2(255); */

   string         agt_email.email_add%type; 
   cStr           varchar2(255);
   

BEGIN
  pos := 1; string := '';
/* cStr := 'Select '|| Col ||' from '|| Tbl ||' where cre_date > '||
Ddate; */
  cStr := 'Select email_add from Agt_Email';   Open cTbl for cStr;
    Loop

       Fetch cTbl into String;
       Exit when cTab%NOTFOUND;


/*       scan_string(string);  --- scan & replace the Accent

characters */
       dbms_output.put_line(pos||' string: ' || String);
       pos := pos + 1;
    End loop;

  Close cTbl;
END Srch_Tbl;
/

  Thanks,
    DTHO. Received on Mon Mar 22 2004 - 15:17:12 CST