Software Applications Programming Errors and solutions.

#!/usr/bin/perl open(FOO,">c:/prod_test.sql"); $create = "Create or replace procedure "; $body = "\nbegin\n null;\n"; $statement = $create."foo("; for ($x=0;$x<8188;$x++){ $statement .= "a$x in varchar2,\n "; } $statement .= "done in varchar2)\n as"; print FOO $statement.$body."end;"; close FOO; at 8187 parameters it compiled. at 8188 it gave a program to large error. its  tested body length by adding "null;" to the body 10,000 times and it didn't mind. One other thing is the 2499 character limit per line.

Compiling and Delivering ASP.NET Pages stages The process of compiling and delivering ASP.NET pages goes through the following stages: 1. IIS matches the URL in the request against a file on the physical file system (hard disk) by translating the virtual path (for example, /site/index.aspx) into a path relative to the site’s Web root (for example,d:\domains\thisSite\wwwroot\site\index.aspx). 2. Once the file is found, the file extension (.aspx) is matched against a list of known file types for either sending on to the visitor or for processing. 3. If this is first visit to the page since the file was last changed, the ASP code is compiled into an assembly using the Common Language Run time compiler, into MSIL, and then into machine-specific binary code for execution. 4. The binary code is a .NET class .dll and is stored in a temporary location. 5. Next time the page is requested the server will check to see if the code has changed. If the code is the same, then the compilat...