| Package Initialization [message #39280] |
Tue, 02 July 2002 21:52  |
bharath
Messages: 30
Registered: November 2000
|
Member |
|
|
hai,
I want to make a package which be having a package variable of type of table of emp and two procedures which will be displaying the count in the variable.
i want to initialize the variable
how can i make it;
it will be great if any body can provide me an example
thanks in advance
bharath
|
|
|
|
| Re: Package Initialization [message #39282 is a reply to message #39280] |
Tue, 02 July 2002 23:57  |
Saga
Messages: 51
Registered: April 2002
|
Member |
|
|
Bharath,
hope this might help.
CREATE OR REPLACE PACKAGE pkg_test AS
TYPE tab IS TABLE OF EMP%ROWTYPE
INDEX BY BINARY_INTEGER;
v_tab tab;
END pkg_test;
You dont need to initialize this variable and u dont need to store the count in any vatiable.
to check the count in the variable simply use v_tab.COUNT
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
