1

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.

Improve this question
4
  • 2
    What's the difference between "Similar to compiling it, and see if there is any error ?" and actually just compiling it and see if there is any error ? Commented Dec 4, 2019 at 17:51
  • How do you compile a stored procedure in SQL Developer ? Sorry, I am new to it. Thank you Commented Dec 4, 2019 at 17:52
  • 2
    You alter it: alter procedure p_test compile; Commented Dec 4, 2019 at 17:54
  • Ah..When I do "alter procedure mySP compile; It gives me "insufficient privileges" Thanks for your help, though. Commented Dec 4, 2019 at 17:59

1 Answer 1

Reset to default
3

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thank you for your help

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.