Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

pls clarify my oracle doubts.

pls clarify my oracle doubts.

pls clarify my oracle doubts.

Hi Friends,

1. What is the difference between Database Stored Procedures and Database Procedures ?

2. If i have a Form Procedure, Database Procedure, PL/SQL Procedure with the same name, when i try to execute the procedure what will be the sequence of execution?

pls revert back to : ggunasundaram@hotmail.com


RE: pls clarify my oracle doubts.

From what i know, there are only two types of procedures in Oracle. Procedures which reffer to procedures stored locally on your machine are the first type of two. Stored Procedures are the ones that you create on your server and they are stored in your database, on your server, are the second ones. Stored Procedures can be accessed from anywhere, whereas, Procedures are only accessible to the end-user apps.

RE: pls clarify my oracle doubts.

Still I am not clear about the doubts.
Diffrenece between database stored procedures and database procedures?

RE: pls clarify my oracle doubts.

PL/SQL is the 3GL created by Oracle to allow coding of logical instructions (if statements, etc.) not possible in straight SQL. PL/SQL allows the creation of procedures (and functions) to group these instructions into parameterised containers. These may be further grouped into packages, which allow nice features like data hiding, improved compilation control, etc. Procedures contained within a package are termed packaged procedures.
Since version 3.0, Oracle Forms has included support for PL/SQL, allowing procedures to be declared within a form; this allows code for validation to be written once and triggered by many actions within a form.
PL/SQL procedues and packages may be stored in the database. By executing a CREATE PROCEDURE x AS <rest of code> instruction as a particular database user, the procedure x will be created as an object in that users schema, in the same way that tables are created using CREATE TABLE ...
If you declare a procedure in a form with the same name as an existing procedure stored in a database schema, then the form procedure will be executed (unless you explicitly reference the user schema version, i.e. user.procedure;)
I hope this helps.

RE: pls clarify my oracle doubts.

H yaffle,
Thank you very much.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close