Please note that this will soon be a disambiguation page. Please see Atlantis (Disambiguation) for more information. Atlantis was a small continent (about the size of present-day Australia...
A procedural language is a programming language in which everything is processed in the order it appears to the computer. In contrast, an object-oriented language is a language in which everything is processed depending on what happens in the program -- user input, errors, or other events.
A stored procedure or in simple a proc is a named PL/SQL block which performs one or more specific task. This is similar to a procedure in other programming languages. A procedure has a header and a body. The header consists of the name of the procedure and the parameters or variables passed to the procedure. The body consists or declaration section, execution section and exception section similar to a general PL/SQL Block.