RE: HELP! Please - Oracle Pro*Cobol

The documentation on the code structures required  

https://docs.oracle.com/cd/E11882_01/appdev.112/e10826/pco07tab.htm#LNPCB007    

Matthew Parker

Chief Technologist

Dimensional DBA

425-891-7934 (cell)

D&B 047931344

CAGE 7J5S7
<mailto:Dimensional.dba_at_comcast.net> Dimensional.dba_at_comcast.net

<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn

<http://www.dimensionaldba.com/> www.dimensionaldba.com
 

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of l.flatz Sent: Wednesday, June 22, 2016 6:49 AM
To: Osborne, Chris; oracle-l_at_freelists.org Subject: AW: HELP! Please - Oracle Pro*Cobol  

Oh, btw it might be possible to set a parameter on the Webserver too. In Cobol it would an code change we have to, there is no such thing as an arraysize unfortunately.  

Thanks  

Lothar      

Von meinem Samsung Gerät gesendet.

• Ursprüngliche Nachricht -------- Von: "Osborne, Chris" <Chris.Osborne_at_sky.uk> Datum: 22.06.16 15:34 (GMT+01:00) An: oracle-l_at_freelists.org Betreff: HELP! Please - Oracle Pro*Cobol

Hi All,    

I was wondering if anyone out there knew anything about Oracle Pro*Cobol?  

We’ve inherited an application that is displaying some performance problems. An example of one is a full table scan report which returns quickly in the database, but very slowly when run from the app server.

If we mess with the array size in SQL plus on the app server, e.g SET ARRAY 5000, then we can get the performance to be broadly similar.  

My question is, how do I set the array size when using Oracle Pro*Cobol?    

Thanks  

Chris        

Information in this email including any attachments may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. SKY and the SKY marks are trademarks of Sky plc and Sky International AG and are used under licence.

Sky UK Limited (Registration No. 2906991), Sky-In-Home Service Limited (Registration No. 2067075) and Sky Subscribers Services Limited (Registration No. 2340150) are direct or indirect subsidiaries of Sky plc (Registration No. 2247735). All of the companies mentioned in this paragraph are incorporated in England and Wales and share the same registered office at Grant Way, Isleworth, Middlesex TW7 5QD.

--
http://www.freelists.org/webpage/oracle-l