Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The reason for the syntax error during the compilation of a PL/SQL procedure caused by the presence of BEGIN TRY and END CATCH statements is that these statements are not valid in PL/SQL. They are used in exception handling blocks in Transact-SQL, which is a different programming language used in Microsoft SQL Server. PL/SQL uses BEGIN EXCEPTION and END EXCEPTION blocks for exception handling. Therefore, the PL/SQL compiler will throw a syntax error when encountering these invalid keywords.