I am calling SQL*Plus from Linux C Shell:
sqlplus username/password @file.sql var1 var2 var3
If I pass a string as var1, how long can this string be?
Is it governed by the OS? In this case:
Linux version 2.6.9-100.ELsmp (mockbuild@x86-010.build.bos.redhat.com) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-11)) #1 SMP Tue Feb 1 12:17:32 EST 2011
Update: Empirical testing yielded the following results:
- A command line argument of 5200 characters gave the error, "Word too long."
- 1300 characters then produced the SQL*Plus error, "string beginning "(000796384..." is too long. maximum size is 239 characters."
- As soon as I got under 239 chars all was well.
I think I'll use sqlldr to overcome this.