Oracle-L: Re: set arraysize in Pro*C

From: <Rick_Cale_at_teamhealth.com>
Date: Mon, 18 Nov 2002 10:03:49 -0800
Message-ID: <F001.00505C52.20021118100349@fatcity.com>

I have not done it for a while but look in the precompiler options. There is an option to increase.

Rick

                                                                                                              
                    Govind.Arumugam@                                                                          
                    alltel.com             To:     Multiple recipients of list ORACLE-L                       
                    Sent by:                <ORACLE-L_at_fatcity.com>                                            
                    root_at_fatcity.com       cc:                                                                
                                           Subject:     set arraysize in Pro*C                                
                                                                                                              
                    11/18/2002 11:48                                                                          
                    AM                                                                                        
                    Please respond                                                                            
                    to ORACLE-L

Dear List-Members,

Some of the batch queries can be improved by increasing the arraysize to 1000 ( the default in SQL*Plus is 15); I would like to find out the equivalent of this in Pro*C programs.

Thanks,
Govind

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Govind.Arumugam_at_alltel.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rick_Cale_at_teamhealth.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Nov 18 2002 - 12:03:49 CST