exnirad@brolga.cc.uq.oz.au (Nirad Sharma) (01/03/91)
Oracle V5, SCO Xenix 2.3.2 /386 (Sorry to burden the net with this but I have just about given up.) I am having problems precompiling a PROC*C program. PRO*C keeps on running out of memory. The error message I am getting is below but on reference to the manual all I get is an error code and the description as given below. I seem to have overlooked one of the Oracle switches but I am unable to find out which. At first I thought that my host variables could possibly be taking up too much space but descreasing them had no effect. What did let PRO*C work was commenting out all references to the offending cursor. make output: ----------- pcc include=/oracle5/c/libs ireclen=158 oreclen=158 rebind=no select_error=no reentrant=yes areasize=64 iname=query.pc Pro*ORACLE: Version 1.1.10 - Production on Fri Jan 4 11:29:30 1991 Copyright (c) 1986, Oracle Corporation, California, USA. All rights reserved. Precompiling query.pc PCC-U-0022: Out of space - unable to allocate 8264 bytes tail query.lis : -------------- 164 165 } 166 no_more_conds: 167 EXEC SQL CLOSE QM_C1; 168 169 170 /* Copy the supplied values into the datum structures */ 171 EXEC SQL WHENEVER NOT FOUND GOTO no_more_mult_vals; 172 EXEC SQL DECLARE QM_C2 CURSOR FOR PCC-U-0022: Out of space - unable to allocate 8264 bytes QUERY_DEFS.H (all host variables defined) ------------ VARCHAR QM_query_categ[11]; int QM_query_num; int QM_line, QM_conjunction, QM_operator_num; VARCHAR QM_negation[1], QM_expression[60], QM_modifier[40]; VARCHAR QM_prefix[170]; VARCHAR QM_suffix[40]; VARCHAR QM_field_name[30], QM_table_name[30], QM_operator_fmt[100]; VARCHAR QM_srch_field_name[30], QM_srch_table_name[30]; VARCHAR QM_multval_conj[10], QM_multval_operator_fmt[100]; VARCHAR QM_str_value1[100], QM_str_value2[100]; float QM_num_value1, QM_num_value2; ------------- Any ideas ? (There is more than enough main memory - ~7 Megs.) Nirad Sharma (exnirad@brolga.cc.uq.oz.au) Continuing Education Unit The University of Queensland AUSTRALIA
rad@genco.bungi.com (Bob Daniel) (01/04/91)
In article <1991Jan3.065418.4767@brolga.cc.uq.oz.au> exnirad@brolga.cc.uq.oz.au (Nirad Sharma) writes: >Oracle V5, SCO Xenix 2.3.2 /386 > 165 } > 166 no_more_conds: > 167 EXEC SQL CLOSE QM_C1; > 168 > 169 > 170 /* Copy the supplied values into the datum structures */ > 171 EXEC SQL WHENEVER NOT FOUND GOTO no_more_mult_vals; > 172 EXEC SQL DECLARE QM_C2 CURSOR FOR I only have experience with version 6 and have not come across the problem but you may need to increase the open_cursors in your init.ora file.