troubleshooting Question

why my pl/sql program not running

Avatar of Sathish David  Kumar N
Sathish David Kumar NFlag for India asked on
Oracle DatabaseSQL
15 Comments1 Solution198 ViewsLast Modified:
what is wrong in the code

declare
cursor c1 is
select  '1' "a" ,'2' "b" ,'3' "c"  from dual ;
begin
for i in  c1
loop
--open c1;
dbms_output.put_line(i.a);
--close c1;
end loop;

end;


its giving error like

                       *
ERROR at line 8:
ORA-06550: line 8, column 24:
PLS-00103: Encountered the symbol "a" when expecting one of the following:
<an identifier> <a double-quoted delimited-identifier> delete
exists prior
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros