#!/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.
Song : O Saathi Re Film : Mukhathar Ka Sikkandhar Uses : C D D# E G A Note : The numbers at the end of the lines indicate line numbers. Pallavi: O saathi re, tere binaa bhi kya jina, tere binaa bhi kya jina A- C D D#....,D D C DD E...C..CA-...,D D C DD E...CC.......1 Play line 1 again phulon men khaliyon men sapnom ki galiyon men GGG...GAGE.. GGG G A G E.................................................2 tere bina kuchh kahin naa E A G E D C D D#.......................................................................3 tere binaa bhi kya jina, tere binaa bhi kya jina D D C DD E....C..CA-..., D D C DDE....CC.............................4 Charanam: har dhadkan men, pyaas hai teri, sanson men teri khushboo hai CCC C D C A-, CCC C D C A-, DDD DED CD EE.. CCCC......................5 is dharthi se, us ambar tak, meri nazar men tu hi tu hai CCC C D C A-, CCC C D C A-, DDD DED CD EE.. CCCC......................6 pyaar yeh tute naa GGG... GAG D#......E............................