| calling a package [message #50825] |
Tue, 09 April 2002 10:55  |
Eugene
Messages: 44
Registered: August 2001
|
Member |
|
|
I have a package spec part of witch is cursor. I need to call this package and pass parameters into that cursor. How do I call the package? Thanks, Eugene
Here is what I have:
CREATE OR REPLACE PACKAGE PD2_PKG AS
Declaration ......
Cursor CUR_ALL_SALES IS
SELECT
....
all_sales_rec cur_all_sales%rowtype;
PROCEDURE PD2_MAIN_P;
PROCEDURE PD2_FIRST_PASS_P (all_sales_rec IN OUT cur_all_sales%rowtype);
PROCEDURE PD2_SECOND_PASS_P (all_sales_rec IN OUT cur_all_sales%rowtype);
END PD2_PKG;
/
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
