how to run stored proc in oracle sql developer tool

The PL/SQL Debugger can also listen for calls to a stored procedure or function and start debugging the PL/SQL when they are called. You can debug your procedure, function, or package by simply setting breakpoints and running it via Oracle Database Explorer, entering in any required parameter values. You should feel right at home in the PL/SQL debugger. The PL/SQL Debugger we’ve added in 21.4 uses the same awesome VS Code debugging infrastructure that you’re already familiar with if you’ve debugged any other language in VS Code, for example, setting breakpoints, viewing, changing, and watching variable values, and viewing the stack. In today’s blog, I’ll highlight the major features in version 21.4, starting with a really exciting one: our new PL/SQL debugger.

We’ve been adding lots of new features with each release and our recent 21.4 release is no exception. I hope you will install this extension (and sign up for an OCI Free Tier account, if you haven’t already) and try it out!

Then you can check in the corresponding SQL scripts into source control alongside your application code. With Oracle Developer Tools for VS Code, you can edit stored procedures and functions and test them. Many Oracle Developers use Visual Studio Code for writing Python, Java, or C# apps that access the database, calling PL/SQL stored procedures or functions from within their code.

As Visual Studio Code runs on Linux, macOS and Windows, this extension can be used by any Oracle developer. In earlier blog posts, I’ve introduced Oracle Developer Tools for VS Code, Oracle’s free extension for Visual Studio Code that enables editing and execution of SQL and PL/SQL (and much more) with Oracle Database and Oracle Autonomous Database. Debugging PL/SQL from inside Visual Studio Code

How to run stored proc in oracle sql developer tool