05-17-2006
ARRAYSIZE determines how fetches work.
If you post your SELECT statement then we can help.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
What are the various way's to fix /proc folder in redhat linux 7.2 and how to verify /proc folder is proper or croupted?
Thank in advance
Bache Gowda (7 Replies)
Discussion started by: bache_gowda
7 Replies
2. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
3. Shell Programming and Scripting
HI,
I'm trying to get this right, please can you help. In my unix korn shell script, I call an oracle stored proc within a package and I specify 3 parameters, 2 of which are IN OUT parameters (i.e. I expect the stored proc to change them and return them back to me).
Does the unix code... (7 Replies)
Discussion started by: csong2
7 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am trying to calculate the CPU Usage by getting the difference between the idle time reported by /proc/stat at 2 different intervals. Now the 4th entry in the first line of /proc/stat will give me the 'idle time'. But I also came across /proc/uptime that gives me 2 entries : 1st one as the... (0 Replies)
Discussion started by: coderd
0 Replies
5. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
6. UNIX for Dummies Questions & Answers
If you are adding the kernel module without any module parameter passing, it should print out following information to info1 file so that user can make read access to info1 file (via, for example, cat /proc/info1):
• Processor type
• Kernel version
• Total number of the processes currently... (1 Reply)
Discussion started by: shekhar.huded
1 Replies
7. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
8. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
9. Shell Programming and Scripting
Greeting everyone. Ok, I have spent the past few days googling for this and I keep hitting a wall. Many results brought me here, but the solutions were not quite right for this.
Basically my script (ksh) is run with an arg for a csv. My script so far appears to be storing the values from my... (4 Replies)
Discussion started by: dezdiggler
4 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT X11R4
xkbfreegeomoverlayrows
XkbFreeGeomOverlayRows(3) XKB FUNCTIONS XkbFreeGeomOverlayRows(3)
NAME
XkbFreeGeomOverlayRows - Free rows in an overlay
SYNOPSIS
void XkbFreeGeomOverlayRows ( overlay, first, count, free_all )
XkbSectionPtr overlay;
int first;
int count;
Bool free_all;
ARGUMENTS
- overlay
section in which rows should be freed
- first
first row to be freed
- count
number of rows to be freed
- free_all
True => all rows are freed
DESCRIPTION
Xkb provides a number of functions to allocate and free subcomponents of a keyboard geometry. Use these functions to create or modify key-
board geometries. Note that these functions merely allocate space for the new element(s), and it is up to you to fill in the values
explicitly in your code. These allocation functions increase sz_* but never touch num_* (unless there is an allocation failure, in which
case they reset both sz_* and num_* to zero). These functions return Success if they succeed, BadAlloc if they are not able to allocate
space, or BadValue if a parameter is not as expected.
If free_all is True, all rows are freed regardless of the value of first and count. Otherwise, the number of rows specified by count are
freed, beginning with the row specified by first in the specified overlay.
RETURN VALUES
Success The XkbFreeGeomOverlayRows function returns Success if there are no allocation or argument errors.
DIAGNOSTICS
BadAlloc Unable to allocate storage
BadValue An argument is out of range
X Version 11 libX11 1.2.1 XkbFreeGeomOverlayRows(3)