Scribd
Upload
11 views3 pages

Oracle PL/SQL Debugging Guide

The document contains a series of SQL and PL/SQL commands executed in an Oracle database environment, highlighting various syntax errors and successful procedure completions. It also includes a note about the document being generated by SkyEss Techno Solutions Pvt. Ltd. for queries and project experience. The content emphasizes the importance of correct syntax in PL/SQL programming.

Uploaded by

Thyaga Rajan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views3 pages

Oracle PL/SQL Debugging Guide

The document contains a series of SQL and PL/SQL commands executed in an Oracle database environment, highlighting various syntax errors and successful procedure completions. It also includes a note about the document being generated by SkyEss Techno Solutions Pvt. Ltd. for queries and project experience. The content emphasizes the importance of correct syntax in PL/SQL programming.

Uploaded by

Thyaga Rajan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Spool Generated For Class of Oracle By Satish K Yellanki

SQL> cl scr

SQL> SELECT
2
SQL> BEGIN
2
3
4
5
6
7
8 END;
9 .
SQL> BEGIN
2
3 END;
4 /
END;
*
ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
<an alternatively-quoted SQL string>

SQL> BEGIN
2 NULL;
3 END;
4 /

PL/SQL procedure successfully completed.

SQL> BEGIN
2 RETURN;
3 END;
4 /

PL/SQL procedure successfully completed.

SQL> DECLARE
2 BEGIN
3 NULL;
4 END;
5 /

PL/SQL procedure successfully completed.

SQL> DECLARE
2 BEGIN
Document Generated By SkyEss Techno Solutions Pvt.
Ltd. For Queries And Live Project Experience in Any
Domain
Mail at: info@[Link] (OR)
Spool Generated For Class of Oracle By Satish K Yellanki

3 NULL;
4 EXCEPTION
5 END;
6 /
END;
*
ERROR at line 5:
ORA-06550: line 5, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
pragma when

SQL> ED
Wrote file [Link]

1 DECLARE
2 BEGIN
3 NULL;
4 EXCEPTION
5 WHEN OTHERS THEN
6* END;
SQL> /
END;
*
ERROR at line 6:
ORA-06550: line 6, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
<an alternatively-quoted SQL string>

SQL> ED
Wrote file [Link]

1 DECLARE
2 BEGIN
3 NULL;
4 EXCEPTION
5 WHEN OTHERS THEN
6 NULL;
7* END;
SQL> /

PL/SQL procedure successfully completed.

SQL> DECLARE
2 V_Num NUMBER(4);
3 V_Bool BOOLEAN;
4 .
SQL> DECLARE
Document Generated By SkyEss Techno Solutions Pvt.
Ltd. For Queries And Live Project Experience in Any
Domain
Mail at: info@[Link] (OR)
Spool Generated For Class of Oracle By Satish K Yellanki

2 x NUMBER(4);
3 .
SQL> cl scr

SQL> DECLARE
2 .
SQL> DECLARE
2 V_Number NUMBER(4);
3 .
SQL> <<MyProgram>>
2 DECLARE
3 V_Number NUMBER(4) := 1234;
4 V_String VARCHAR2(10) := 'SAMPLE'; --A Variable To Hold String
5 /*
6 Executable Routine
7 is About To Begin.
8 Here We Write The
9 Operational Logic.
10 */
11 BEGIN
12 .
SQL> SPOOL OFF

Document Generated By SkyEss Techno Solutions Pvt.


Ltd. For Queries And Live Project Experience in Any
Domain
Mail at: info@[Link] (OR)

You might also like