|
-
Hey,
In order to call the package_demo.getRecords procedure simply declare a PL/SQL table type and send it as parameter to the procedure.
Just use :
declare
employees EmpTabType;
begin
package_demo.getRecords(employees);
end;
you can fill the PL/SQL Table with values before you send it to the procedure in these matters:
1) if you are using 8i version use a select clause with bulk collect :
select empno,ename bulk collect into employees from emp;
2) if you are using 8.0.x version loop over the emp table with a cursor and insert values into employees table.
for i in 1..count(emp) LOOP
fetch cur into employees(i);
end LOOP;
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
|