Tutorials
Oracle 9i
Tutorial 15: Oracle 9i : Oracle Packages
Tutorial 15: Oracle 9i : Oracle Packages - Page 2
Private and Public Items in packages
Items declared in package body are private. They can only be accessed within the package. Where as items declared in package specification is public and is available outside package. It is explained in the following example.
The package shown in Fig 1 contains a variable Age_limit which is accessed by the program given below.

Overloading Packaged Subprograms:
Similar to the overloading concept in other programming languages PL/SQL also allows you to overload its subprograms.
We can have more than one subprogram with the same name within a package
Following examples better explain this concept.



Writing Cursor spec and body separately using Packages
The cursor specification can be written separate from its body using packages. It allows you to change cursor body without changing the cursor specification. Cursor coded in the package spec need to have a return type.
CURSOR cursor_name [(parameter [, parameter]...)] RETURN return_type;
The following examples explain how cursor can be declared and defined using packages.


Below given is the example that explains how to access the cursor values.

First Page: Tutorial 15: Oracle 9i : Oracle Packages
| Can we call cursor as an anonymous block |
| pl/sql packeges concepts are easy to understand |
|
thanx a billion , where million is too little :) for this clear , helpful and specific explanation . it really helped me and made that stuff crystal clear to me .. thanx again . |
| You will provide somemore Examples |
| It is very simple and example also easy to understand.It is realy helpful to me |
| it is very good but you should provide some more examples |
| it is good but more examples ,some complex ones, should be provided. |
|
can any body explain me how package provides information hiding facility in oracle explain with examples pls help me... |
|
can anybody answer this query: i need to check if a package of the name 'x' exists in a particulas db. what will be the sql command for that? select x from dual; doesnt work. |
|
you should query the user_source table as such: SELECT text from user_source WHERE name = 'x' AND type = 'PACKAGE'; or something like that |
|
you should query the user_source table as such: SELECT text from user_source WHERE name = 'x' AND type = 'PACKAGE'; |
|
I have about 250 procedures and each 25 is a group. These procedures are created dynamically by using definition tables. What I want to do is to group each 25 procedure in a package but I can not execute these procedures in a package since the length of the string is to big to execute. I use execute immediate or dbms_sql.parse to execute the string. What should I do ? Is there a method of adding procedures to a package ? Thanks in advance. |