Re: Need help: PL/SQL and Cursors

Paul Mattes (mattesp_at_pipeline.com) wrote:
: *,
: I've got a proc in which I need to dynamically create a table name and pass
: it into a cursor to select
: stuff out. When I do, however, I get this thing:
:
(Remaining Text Deleted)

Paul,

The only way to do dynamic sql in a stored procedure is to use an Oracle supplied package named dbms_sql. This package existed but was unsupported in version 7.0. It is supported in 7.1 but has been changed somewhat from the 7.0 version.

Hope this helps,

Chris Cummings                         |          Recruiting   Oracle  CDE 
Dallas Softworks, Inc.                 |          Developers for immediate
chrisc_at_netcom.com                      |          contract  positions   in 
Fax (214) 351-2139                     |          Dallas.