12-27-2011
Thank you Cero, I had doubts that there is a way somewhere to do this. but it's clear as there is no way for such actions.
Would like to thank all participants once again, Thank You!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. UNIX for Advanced & Expert Users
Hi,
I want to input unix variable to sqlplus.The following is working fine
sqlplus username/password @dummy.sql param1 param2 << EOF
create user $1 identified by $2;
EOF
But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that??
Thanks... (3 Replies)
Discussion started by: sakthi.abdullah
3 Replies
3. Shell Programming and Scripting
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
Discussion started by: kripssmart
3 Replies
4. Shell Programming and Scripting
Hi,
I am writing a script which creates an external table using a shell script. My requirement is like this.
Usage: . ./r.ksh <table_name> - this should create an external table.
e.g . ./r.ksh abc - this should create an external table as abc_external.
How do i achieve this? Please... (5 Replies)
Discussion started by: Anaramkris
5 Replies
5. Shell Programming and Scripting
Hi there,
I am trying to call a shell script from a Perl script. here is the code:
@args = ("sh", "someshellprg.sh", "a file handler", "an array");
system(@args) == 0
or die "system @args failed: $?";
in the shell program, I examine if the arguments exits using:
if
then echo... (5 Replies)
Discussion started by: pinkgladiator
5 Replies
6. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
7. Shell Programming and Scripting
Hi All,
I'm new to Linux and scripting, apologies in advance for 'stupid' questions.
Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work.
here is my code.
#!/bin/sh
TERM=vt100
export TERM... (4 Replies)
Discussion started by: Mahomed
4 Replies
8. Shell Programming and Scripting
Hi ,
I am using below code :
for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'`
do
ORACLE_SID=$i
export ORACLE_SID;
dest=`sqlplus "/ as sysdba" <<EOF
set heading off feedback on verify off
select DESTINATION from v\\$archive_dest where target in... (5 Replies)
Discussion started by: admin_db
5 Replies
9. Shell Programming and Scripting
Apologies if this is the incorrect forum.There is an issue in the function call I am facing while calling the same from a unix shell scripts.
Basically, I want the ref cursor to return values to a variable in sqlpus. The function call is currently saved in a ".txt" file
in a unix location. I want... (7 Replies)
Discussion started by: amvip
7 Replies
10. Shell Programming and Scripting
Hello,
I have file (PARFILE) with string on first line:
INCLUDE=SCHEMA:"IN\( 'SCHEMA1','SCHEMA2','SCHEMA3' \)"In .sh script I use:
....
IMPORT_SCHEMA=`awk 'NR==1{print $2}' ${PARFILE}`
...print $2 is because 'SCHEMA1','SCHEMA2','SCHEMA3' is 2nd column in file
echo "$IMPORT_SCHEMA"... (5 Replies)
Discussion started by: DjukaZg
5 Replies
LEARN ABOUT CENTOS
xkbresizekeyactions
XkbResizeKeyActions(3) XKB FUNCTIONS XkbResizeKeyActions(3)
NAME
XkbResizeKeyActions - Change the number of actions bound to a key
SYNOPSIS
XkbAction * XkbResizeKeyActions (XkbDescRec *xkb, int key, int needed);
ARGUMENTS
- xkb keyboard description to change
- key keycode of key to change
- needed
new number of actions required
DESCRIPTION
The xkb parameter points to the keyboard description containing the key whose number of actions is to be changed. The key parameter is the
keycode of the key to change, and needed specifies the new number of actions required for the key.
XkbResizeKeyActions reserves the space needed for the actions and returns a pointer to the beginning of the new array that holds the
actions. It can change the acts, num_acts, and size_acts fields of xkb->server if it is necessary to reallocate the acts array.
If needed is greater than the current number of keysyms for the key, XkbResizeKeyActions initializes all new actions in the array to NoAc-
tion.
Because the number of actions needed by a key is normally computed as width * number of groups, and XkbResizeKeyActions does not modify
either the width or number of groups for the key, a discrepancy exists on return from XkbResizeKeyActions between the space allocated for
the actions and the number required. The unused entries in the list of actions returned by XkbResizeKeyActions are not preserved across
future calls to any of the map editing functions, so you must update the key actions (which updates the width and number of groups for the
key) before calling another allocator function. A call to XkbChangeTypesOfKey updates these.
If any allocation errors occur while resizing the number of actions bound to the key, XkbResizeKeyActions returns NULL.
SEE ALSO
XkbChangeTypesOfKey(3), XkbResizeKeySyms(3)
NOTES
A change to the number of actions bound to a key should be accompanied by a change in the number of symbols bound to a key. Refer to XkbRe-
sizeKeySyms for more information on changing the number of symbols bound to a key.
X Version 11 libX11 1.6.0 XkbResizeKeyActions(3)