PL/SQL (MOSC)

MOSC Banner

error while creating a procedure

edited Oct 29, 2014 5:08PM in PL/SQL (MOSC) 2 commentsAnswered

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 || ' ' );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center