10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
i have say x number of procedure to run, ie i have one procedure which accepts variable and i need that to run in parallel and capture the error code if in case if it fails through the unix.
sqlplus <EOF> exec test_t (abc,124); </EOF>
sqlplus <EOF> exec test_t (abc,125); </EOF>
sqlplus <EOF>... (2 Replies)
Discussion started by: ATWC
2 Replies
2. UNIX for Dummies Questions & Answers
I'm trying to find the version of the underlying Oracle forms from out Unix Server.
I have tried
frmcmp.sh -h
but I get the error
frmcmp.sh -h : not found
Its a Unix Sun server running an oracle database
Any ideas? (1 Reply)
Discussion started by: dbajtr
1 Replies
3. Shell Programming and Scripting
Hi Everyone,
I want to create a script where i need to run the oracle stored procedure from unix script and get the output(sequence number ) into a variable which i will pass in my datastage job.
Below is my stored procedure:-
DECLARE
P_TRANSTYPE VARCHAR2(20);
... (4 Replies)
Discussion started by: prasson_ibm
4 Replies
4. Shell Programming and Scripting
for j in $(du -h $1| awk '{printf("%100-s \n",$2)}')
do
for a in $(ls -time $(find $j -name '*.txt') | awk '{printf("\n%s %s %s %s %s",$4,$7,$8,$10,$11)}')
do
echo "$a">output.txt
done
done
exit 0
echo "Password : xxxxxx " > LOG/BGH_$3.out (0 Replies)
Discussion started by: utoptas
0 Replies
5. Shell Programming and Scripting
Please help me how to pass some unix vairable to oracle. I have used below , but not displaying passed (inval) value.
calling()
{
sqlplus -s $1/$2@$3 <<EOF
begin
exec call_sql($4);
end;
exit
EOF
}
calling user pwd inst value1... (17 Replies)
Discussion started by: Jairaj
17 Replies
6. Shell Programming and Scripting
Hi Dudes :)
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
declare
res varchar2(10);
begin
odm_load_check('PRE_SANITY',res);
dbms_output.put_line(res);
end;
select * from error_log;
truncate table error_log;
select * from test; (1 Reply)
Discussion started by: shirdi
1 Replies
7. Shell Programming and Scripting
Hi
i want to call a oracle stored procedure from unix (using bash shell).
consider this is my oracle stored procedure with parameter
create procedure testproc(name IN varchar, age IN Number, id OUT Number )
AS
begin
id=1;
dbms_output.put.line('successfull validation')
end;... (6 Replies)
Discussion started by: barani75
6 Replies
8. Shell Programming and Scripting
using the script below I want to pass a parameters thorugh my sql
call(@/unixsxxx/xxxx/helpenv.sql emptab ) as input into an oracle procedure xxxx_package.proc1(%1,emptab); . I tried %1 but it does not work. Any suggestions.
#!bin/ksh
set -x
#
export... (0 Replies)
Discussion started by: TimHortons
0 Replies
9. Shell Programming and Scripting
Hi All,
Does anyone have any solutions for passing back multiple variables back to the SHELL from a call to an ORACLE procedure:
eg
#username='scott'
#password='tiger'
#database='orcl'
username='ITGCD03D03'
password='tC5epIew'
database='ITGCD03D'
sqlplus -s... (4 Replies)
Discussion started by: satnamx
4 Replies
10. UNIX for Dummies Questions & Answers
Does anyone know how to call an Oracle stored procedure from a Unix script? (1 Reply)
Discussion started by: ssmiths001
1 Replies
XSetScreenSaver() XSetScreenSaver()
Name
XSetScreenSaver - set the parameters of the screen saver.
Synopsis
XSetScreenSaver(display, timeout, interval, prefer_blanking,
allow_exposures)
Display *display;
int timeout, interval;
int prefer_blanking;
int allow_exposures;
Arguments
display Specifies a connection to an X server; returned from XOpenDisplay().
timeout Specifies the time of inactivity, in seconds, before the screen saver turns on.
interval Specifies the interval, in seconds, between screen saver invocations. This is for intermittent changes to the display, not
blanking.
prefer_blanking
Specifies whether to enable screen blanking. Possible values are DontPreferBlanking, PreferBlanking, or DefaultBlanking.
allow_exposures
Specifies the current screen saver control values. Possible values are DontAllowExposures, AllowExposures, or DefaultExposures.
Description
XSetScreenSaver() sets the parameters that control the screen saver. timeout and interval are specified in seconds. A positive timeout
enables the screen saver. A timeout of zero (0) disables the screen saver, while a timeout of -1 restores the default. An interval of
zero (0) disables the random pattern motion. If no input from devices (keyboard, mouse, etc.) is generated for the specified number of
timeout seconds, the screen saver is activated.
For each screen, if blanking is preferred and the hardware supports video blanking, the screen will simply go blank. Otherwise, if either
exposures are allowed or the screen can be regenerated without sending exposure events to clients, the screen is tiled with the root window
background tile, with a random origin, each interval seconds. Otherwise, the state of the screen does not change. All screen states are
restored at the next input from a device.
If the server-dependent screen saver method supports periodic change, interval serves as a hint about how long the change period should be,
and a value of zero (0) hints that no periodic change should be made. Examples of ways to change the screen include scrambling the color
map periodically, moving an icon image about the screen periodically, or tiling the screen with the root window background tile, randomly
reoriginated periodically.
For more information on the screen saver, see Volume One, Chapter 15, Other Programming Techniques.
Errors
BadValue timeout < -1.
See Also
XActivateScreenSaver(), XForceScreenSaver(), XGetScreenSaver(), XResetScreenSaver().
Xlib - Screen Saver XSetScreenSaver()