Re: Pro*C and source modules

From: Branko Koprivica <perpetum_at_interlog.com>
Date: Fri, 19 Jun 1998 14:21:10 -0300
Message-ID: <358A9E06.A8B9D6FC_at_interlog.com>


You could use REF cursor and move embedded stuff to stored procedures Branko Koprivica

Dave Boswell wrote:

> I'm wondering if someone can help me ...
>
> We have developed a program that uses dynamic SQL (type 4) in Pro*C to
> do extracts from our database and it works fine. The problem is that we
> want to move the extract portion into another module that we can link
> with other sources. How do you pass references to the embedded stuff
> between modules? We thought that cursor variables would work but they
> can't be used with dynamic queries. Is this not possible? Do we have to
> use the OCI instead? If we have to use the OCI, are there any libraries
> that make the OCI more 'user friendly'?
>
> Thanks in advance,
> Dave Boswell
Received on Fri Jun 19 1998 - 19:21:10 CEST

Original text of this message