|
-
use this:
create or replace package package_demo
is
type EmpRecType is RECORD (ID EMP.EMPNO%type,
NAME EMP.ENAME%type);
type EmpTabType is TABLE of EmpRecType;
procedure call_getRecords;
procedure getRecords(emp_table EmpTabType);
end package_demo;
/
create or replace package body package_demo
is
employees EmpTabType;
procedure call_getRecords
is
begin
getRecords(employees);
end call_getRecords;
procedure getRecords(emp_table in EmpTabType)
is
begin
null;
-- perform all you want here...
end getRecords;
end package_demo;
now you can use in SQL*Plus:
execute package_demo.call_getRecords;
or use just package_demo.call_getRecords in a begin-end block.
Good Luck.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|