CODEWITHSUNDEEP
oracle-databaseoracle11gsyntaxcompilationoracle-sqldeveloper
faujong
faujong

Reputation: 1129

How to check syntax Oracle stored procedure in SQL Developer?

In SQL Server Management Studio, there is a "Parse" menu where you can check the syntax of the stored procedure, without running the stored procedure. Is there a similar thing in Oracle SQL Developer, to check the syntax of the codes in the stored procedure without executing it ? Similar to compiling it, and see if there is any error ?

Thank you.

Upvotes: 1

Views: 3847

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22457

Yes...but it does that as you type, it's not an on-demand thing. enter image description here

There is no...hey compiler have a look at this, but don't actually compile it feature. Our parser is client side and is following the rules of the Oracle SQL and PL/SQL syntax and applies that to the code it sees.

Upvotes: 3

Related Questions