pls clarify my oracle doubts.

[ggunasundaram]

Hi Friends,<br>
<br>
1. What is the difference between Database Stored Procedures and Database Procedures ?<br>
<br>
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?<br>
<br>
pls revert back to : <A HREF="mailto:ggunasundaram@hotmail.com">ggunasundaram@hotmail.com</A><br>
<br>
Regards<br>
Guna

 

[farman]

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.

 

[ggunasundaram]

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

 

[yaffle]

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.<br>
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.<br>
PL/SQL procedues and packages may be stored in the database. By executing a CREATE PROCEDURE x AS &lt;rest of code&gt; 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 ...<br>
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<br>
I hope this helps.

 

[ggunasundaram]

H yaffle,<br>
Thank you very much.<br>
Guna