Ask Your Question
1

What is 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?

asked 2023-06-27 17:38:49 +0000

lakamha gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2023-06-27 18:00:02 +0000

woof gravatar image

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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2023-06-27 17:38:49 +0000

Seen: 13 times

Last updated: Jun 27 '23