07-02-2012
It depends on how you are using the variable in the proc.
If you are using the variable on a IN statement then it would have the maximum input limit. Oracle has some limit which yield you the error ORA-00939
Worth verifying the proc first before the shell.
10 More Discussions You Might Find Interesting
1. HP-UX
Greetings all:
I am still new to Unix environment and I need help with the following requirement.
I have a large sequential file sorted on a field (say store#) that is being split into several smaller files, one for each store. That means if there are 500 stores, there will be 500 files. This... (1 Reply)
Discussion started by: SAIK
1 Replies
2. UNIX for Advanced & Expert Users
I have 3 columns in an excel sheet.
c1 c2 c3
EIP_ACCOUNT SMALL_TS_01 select A.* from acc;
All the above 3 col shoud be passed a variable in the unix code.
1.How to read an excel file
2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies
3. Shell Programming and Scripting
Hi, I've just started on unix shell scripting a few days ago. I tried look for the solution to my problem over the net but to no avail.
The objective of my script is to count the number of records in a particular table from a Oracle database.
Ok, here's my problem, when I run this script:
... (1 Reply)
Discussion started by: mervinboyz
1 Replies
4. Shell Programming and Scripting
Hi,
i have a problem writing a script.
Actually i have many files which contains some data, now the last line has some data as in the format : 2556||04-04-10
now i want to do tail -1 filename.txt and store the result into a variable which will be used later for some other calculations.
My... (7 Replies)
Discussion started by: fidelis
7 Replies
5. Shell Programming and Scripting
Respected All,
Kindly help me out.
I have got file listings in a directory like this:
-rw-r--r-- 1 root root 115149 2011-11-17 07:15 file1.stat.log
-rw-r--r-- 1 root root 115149 2011-11-18 08:15 file2.stat.log
-rw-r--r-- 1 root root 115149 2011-11-19 09:15 file3.stat.log
-rw-r--r-- 1... (2 Replies)
Discussion started by: teknokid1
2 Replies
6. Shell Programming and Scripting
Hi All,
This is my first post!! :)
How to store huge data in a single variable in csh.
Right now i can store upto ~700kb of data. I still want to store more data and i dont want to use perl.
Is there any method to store like that...Please let me know..
Thanks (3 Replies)
Discussion started by: vickra
3 Replies
7. Shell Programming and Scripting
Am using a find command in my script .The output may be one or more. I need to store those values in a array and need to access those. Am unable to find the solution . Any help on this will be helpful.
if
< code>
else a=<find command output which gives the file name either 1 or more>
if 1... (1 Reply)
Discussion started by: rogerben
1 Replies
8. Shell Programming and Scripting
This basic code works.
I have a very long list, almost 10000 lines that I am building into the array. Each line has either 2 or 3 fields as shown in the code snippit. The array elements are static (for a few reasons that out of scope of this question) the list has to be "built in".
It... (5 Replies)
Discussion started by: sumguy
5 Replies
9. Shell Programming and Scripting
hello,
i need a bit of help on how to do this effectively in bash without a lot of extra looping or massive switch/case
i have a long array of M elements and a short array of N elements, so M > N always. M is not a multiple of N.
for case 1, I want to stretch N to fit M
arrayHuge
H = (... (2 Replies)
Discussion started by: f77hack
2 Replies
10. UNIX for Beginners Questions & Answers
Hi
I have the following sample of data: my full data dimention is 900,000* 1119
rs987435 C G 1 1 1 0 2
rs345783 C G 0 0 1 0 0
rs955894 G T 1 1 2 2 1
rs6088791 ... (7 Replies)
Discussion started by: marwah
7 Replies
LEARN ABOUT FREEBSD
plimit
plimit(1) User Commands plimit(1)
NAME
plimit - get or set the resource limits of running processes
SYNOPSIS
plimit [-km] pid...
plimit {-cdfnstv} soft,hard... pid...
DESCRIPTION
If one or more of the cdfnstv options is specified, plimit sets the soft (current) limit and/or the hard (maximum) limit of the indicated
resource(s) in the processes identified by the process-ID list, pid. Otherwise plimit reports the resource limits of the processes identi-
fied by the process-ID list, pid.
Only the owner of a process or the super-user is permitted either to get or to set the resource limits of a process. Only the super-user
can increase the hard limit.
OPTIONS
The following options are supported:
-k On output, show file sizes in kilobytes (1024 bytes) rather than in 512-byte blocks.
-m On output, show file and memory sizes in megabytes (1024*1024 bytes).
The remainder of the options are used to change specified resource limits. They each accept an argument of the form:
soft,hard
where soft specifies the soft (current) limit and hard specifies the hard (maximum) limit. If the hard limit is not specified, the comma
may be omitted. If the soft limit is an empty string, only the hard limit is set. Each limit is either the literal string unlimited, or a
number, with an optional scaling factor, as follows:
nk n kilobytes
nm n megabytes (minutes for CPU time)
nh n hours (for CPU time only)
mm:ss minutes and seconds (for CPU time only)
The soft limit cannot exceed the hard limit.
-c soft,hard Set core file size limits (default unit is 512-byte blocks).
-d soft,hard Set data segment (heap) size limits (default unit is kilobytes).
-f soft,hard Set file size limits (default unit is 512-byte blocks).
-n soft,hard Set file descriptor limits (no default unit).
-s soft,hard Set stack segment size limits (default unit is kilobytes).
-t soft,hard Set CPU time limits (default unit is seconds).
-v soft,hard Set virtual memory size limits (default unit is kilobytes).
OPERANDS
The following operands are supported.
pid Process ID list.
EXIT STATUS
plimit returns the exit value zero on success, non-zero on failure (such as no such process, permission denied, or invalid option).
FILES
/proc/pid/* process information and control files
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesu |
+-----------------------------+-----------------------------+
SEE ALSO
ulimit(1), proc(1), getrlimit(2), setrlimit(2), proc(4), attributes(5),
SunOS 5.10 8 Jun 1998 plimit(1)