Create a simple stored procedure and execute on PL/SQL Developer Version 8.0

[Alex98]

Hi all,

Could someone please give me an example of creating a fool proof simple stored procedure and on how to execute this on PL/SQL Developer Version 8.0 so that I have a basic understanding of this topic?

Would you also happen to know any good online resources on learning stored procedure (Oracle , even better if specific for PL/SQL Developer)?

Thank you!

Cheers,
Alex

 

[Marco Kalter]

For creating a stored procedure, see chapter 3 "Writing programs" in the User's Guide.
For executing a stored procure, see chapter 4 "Testing programs" in the User's Guide.

You can open the User's Guide from within PL/SQL Developer, of open it from the file system in the PL/SQL Developer installation directory (Manual.pdf).

 

[Alex98]

Thank you Marco, I'll go and study that guide then. Thank you.