Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ProC Declaring host arrays in a separate class

Re: ProC Declaring host arrays in a separate class

From: Ed Prochak <edprochak_at_magicinterface.com>
Date: Wed, 01 May 2002 12:26:38 GMT
Message-ID: <3CD00B20.657992D0@magicinterface.com>


sounds like you did not reun the ProC precompiler first. If you did run the ProC precompiler, all the EXEC... lines would be commented out.

dreadlord76 wrote:
>
> I need to convert an existing single-threaded ProC application to be
> multi-threaded. We use host arrays to speed up bulk processing.
> Currently, host arrays are declared in a global scope:
>
> EXEC SQL BEGIN DECLARE SECTION;
> long my_sample_id[100];
> EXEC SQL END DECLARE SECTION;
>
> What I like to do, is to put these arrays in a helper class, and have
> instances of the helper class associated with each sql_context. To do
> this, I started by creating a Header file for the helper class.
>
> When the VC++ compiler tries to compile after ProC got through the .pc
> file, the compiler barfs on the "EXEC SQL BEGIN DECLARE SECTION;" in
> the header file.
>
> So is what I need to do possible? Can I declare host variables in a
> class so I can have multiple instances of them, instead of declaring
> them globally, or make them class specific?
>
> I can declare them in the scope of the class using the host arrays,
> but not all instances of the class needs the host arrays, and the
> memory allocation would be pretty large and wasteful.
>
> Thanks in advance!
>
> dreadlord76

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com
Received on Wed May 01 2002 - 07:26:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US