Re: Array fetching in Pro*C

Ye,

Are both tables in Oracle? If they are it would be a simple thing to create a database link and select across the link. Or create a snapshot based on the remote table.

Phil M.

In article <5f219j$58m_at_physics1.usc.edu>, ysun_at_physics1.usc.edu says...
>
>Hi,
>
>We are writing an interface to load data from remote database tables to local
>tables. From remote tables to local, it goes through SQL*NET. So we
>are trying to do it in a way of best performanence by using host array
>in Pro*C. However we don't like to use fixed array size for two reasons:
>1) It is hard to tune at the time of installation;
>2) Waste too much memory just to hold these big trunck of data.
>
>If we use dynamic memory allocation, we have to do malloc for each individual
>element array since Oracle Pro*C precompiler does not take array of structures
>like this:
> #typedef struct _foo
> {
> elmt_1;
> elmt_2;
> ...
> } foo;
>
> foo Array[size];
>
>Being unable to do this will force us to treat each element
>individually. This not only makes the programming dreadful with
>so much mallocs and frees, but also could potentially slow down the
>process. Neither seems good choice to use.
>
>We are using Oracle 7.1.6 and Pro*C 2.2.
>
>Thanks in advance!
>
>
>Best Regards
>
> Ye Sun, Ph.D.
> Department of Physics and Astronomy
> University of Southern California
> Los Angeles, CA 90089-0484
> e-mail: ysun_at_usc.edu
Received on Thu Mar 27 1997 - 00:00:00 CST