parameter passing in the weak cursor
Date: 22 Mar 2004 13:17:12 -0800
Message-ID: <384dc9a9.0403221317.37996255_at_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 - 22:17:12 CET