<div>
Have you tried &quot;EXECUTE IMMEDIATE&quot;:<br />
<br />
EXEC-SQL EXECUTE IMMEDIATE &quot;ALTER SESSION SET SORT_AREA_SIZE=100000000&quot;;<wbr /><br />
END EXEC<br />
<br />
I don't know pro-cobol, but execute immediate usually just passes whatever string you put in quotes straight to the engine.<br />

</div>


Have you tried "EXECUTE IMMEDIATE":

EXEC-SQL EXECUTE IMMEDIATE "ALTER SESSION SET SORT_AREA_SIZE=100000000";
END EXEC

I don't know pro-cobol, but execute immediate usually just passes whatever string you put in quotes straight to the engine.


<div>
Try,<br />
<br />
EXEC SQL ALTER SESSION SET SORT_AREA_SIZE=100000000;<br />
<br />
HTH<br />
<br />
Ali<br />

</div>


Try,

EXEC SQL ALTER SESSION SET SORT_AREA_SIZE=100000000;

HTH

Ali


<div>
<div class="content wysiwyg-content">
Oracle 7.3.3<br />
PreCompiler: Pro Cobol<br />
<br />
Does anyone remember how can I run this statement inside the ProCobol:<br />
<br />
Alter session set sort_area_size=100000000;<br />
<br />
I tried the following:<br />
EXEC-SQL EXECUTE<br />
&nbsp; ALTER SESSION SET SORT_AREA_SIZE=100000000;<br />
END EXEC<br />
<br />
<br />
Iget the following compilation error:<br />
UNDECLARE SQL IDENTIFIER &quot;ALTER&quot; at line...<br />
<br />
<br />
<br />
Thanks<br />

</div>
</div>


Oracle 7.3.3
PreCompiler: Pro Cobol

Does anyone remember how can I run this statement inside the ProCobol:

Alter session set sort_area_size=100000000;

I tried the following:
EXEC-SQL EXECUTE
  ALTER SESSION SET SORT_AREA_SIZE=100000000;
END EXEC


Iget the following compilation error:
UNDECLARE SQL IDENTIFIER "ALTER" at line...



Thanks


Pre-Compiler: how to execute an &quot;alter session&quot; statement?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

COBOL (Common Business-Oriented Language) is a programming language with English-like syntax. It is readable but verbose compared to other programming languages. CODASYL (Conference on Data Systems Languages) created COBOL in 1959 based on design work from Grace Hopper. It was standardized in 1968. COBOL is still present in large-scale batch processing and transaction processing where legacy applications are being used, usually in government, financial, and administrative systems.

Pre-Compiler: how to execute an &quot;alter session&quot; statement?

Pre-Compiler: how to execute an "alter session" statement?