I used Quest CodeGen generate the package for the table: Scott.emp
The package has compiled successfully.
Then I inputed:
select emp_qp.allrows from dual;
ORA-00902: invalid datatype
select emp_qp.allrows_cv from dual;
Only return a cursor but don't show the data.
select * from table(emp_qp.allrows);
ORA-00902: invalid datatype
How can I get the data from the query package?
|
