DBMS_SQL for a select statement?

From: Ng TC <tcng_at_yas.com.sg>
Date: 1998/06/05
Message-ID: <01bd9031$428128c0$ebce2aca@mis1-235.yas.com.sg>#1/1

Hi,

I am writing a package spec/body with a function.

Within the function, I want to do a 'select ... into ... from ... where ..'.

My tables are in remote database, so I have to use database_link '@yasfn107_apps'.

But I also want the database link to be dynamic. Someone suggested using DBMS_SQL package to do it. But DBMS_SQL does not allow 'select ... into...', so I removed the 'into...' portion and DBMS_SQL runs fine without error/exception.

But now my problem is: how do I get the values returned from this select statement????

Please help.

Thanks.

Regards,
Tse Chong
email : tcng_at_yas.com.sg Received on Fri Jun 05 1998 - 00:00:00 CDT