Re: Dynamic SQL Cursors ???

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 18 Sep 2002 06:39:21 +0200
Message-ID: <9n0gou0f8klf94gn5qi440u6ok43cb78c0@4ax.com>

On Wed, 18 Sep 2002 03:33:43 GMT, "Michael Lackey" <michael.lackey_at_shaw.ca> wrote:

>I would appreciate any advise with dynamic cursors and with my problem.

Your problem is you don't post a version, and no one here has a crystall ball.

You'll need dynamic sql.
As you, as many others fail to post a version, and the answer is version dependent, I'm not going to revise your code. You need to study dbms_sql (pre 8i)
and native dynamic sql (cursor variables/ ref cursor) in 8i and beyond.
Examples on the net and in the documentation and in Steve Feuerstein's books abound.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Sep 17 2002 - 23:39:21 CDT