error while creating a procedure
Hello,
While creating a procedure below error is coming:
Error(12,19): PLS-00103: Encountered the symbol "C1" when expecting one of the following: := . ( @ % ;
Procedure Code
create or replace
PROCEDURE UP_ZC_CONTENT_SEARCH (SearchFor varchar2)
IS
/* Declaration */
/* Define the cursor */
CURSOR zc_cur IS
SELECT table_name FROM clarity_tbl where table_name like 'ZC_%' ;
/* declare var */
zc_rec zc_cur%rowtype;
BEGIN
FOR zc_rec in zc_cur
LOOP
CURSOR c1 is select title from zc_rec.table_name where title = SearchFor;
c1_rec c1%rowtype;
For c1_rec in c1
Loop
dbms_output.put_line(c1_rec.title || ' ' );