Re: Need help for dbms_sql pack.

INFODOC 2 lic wrote:
>
> Did anybody already succeeded in passing an ENTIRE 'select' statement
> as the parameter of a procedure using the dbms_sql package ?? Is this
> possible ?
>
> Thanks a lot in advance for any help !!

Several times.
A possible error might be that the owner of your pl/sql package has no rights on the table. Or no synonym so you should use  select * from foreign_user.table_name
instead of
 select * from table_name

succes,
Rudi Demeulenaere
rdm_at_datafront.be Received on Tue Dec 17 1996 - 00:00:00 CET