Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Hello All,
I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script.
I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable).
But, what if we want to return multiple values?
One option I... (4 Replies)
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
hi,
Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable...
Thanks in advance... (5 Replies)
Hi All ,
I am trying to pass a value from sqlplus to korn shell .
There is a table tab1 in Oracle that has a column userdate.
I need to pass the userdate to the korn shell . This is what I am doing .
VALUE=`sqlplus -silent username/password << END
set pagesize 0 feedback off verify off... (14 Replies)
Hi scripting experts.
I have some coding challenges that I'm hoping you can help me out.
I have one file#1 that contains the following sql statement that spans over multiple lines:
sql Select /*+ use_has(a,b) */ *
from customer a,
customer_address b
where a.id = b.id... (1 Reply)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
I have written a script which will take input parameter as another script.
However, if the script passed as input parameter has parameters then this script doesn't work.
I have a script b.ksh which has 1 and 2 as parameters
I have a script c.ksh which has 3,4 and 5 as parameters
vi a.ksh... (1 Reply)
Discussion started by: Vee
1 Replies
LEARN ABOUT DEBIAN
ecaccess-event-send
ECACCESS-EVENT-SEND(1p) User Contributed Perl Documentation ECACCESS-EVENT-SEND(1p)NAME
ecaccess-event-send - Trigger an ECaccess Event
SYNOPSIS
ecaccess-event-send -version|-help|-manual
ecaccess-event-send [-debug] [-environment variables] [-delay duration] [-at date] event-id sequence
DESCRIPTION
Allow triggering the event specified by its event-id. The sequence number should always be greater than the last sequence submitted. The
specified environment parameters are passed to the jobs before submissions. The triggering of the event can also be delayed or started at a
later time if required. As a result the number of notification(s) updated is displayed.
ARGUMENTS
event-id
The identifier of the Event to trigger.
sequence
The sequence number for the triggering (must be an integer between 0 and 2147483647).
OPTIONS -environment variables
Specify which environment variables to pass to the jobs. Multiple variables should be separated by a semi-column (e.g.
"PARAM1=xxx;PARAM2=yyy").
-delay duration
Allow delaying the submission of the event (default: no delay). The duration is specified in [w]eeks, [d]ays, [h]ours, [m]inutes or
[s]econds (e.g. 1w or 2d).
-at date
Specify the starting date for the event (default: immediate submission). The format of the date is "yyyy-MM-dd HH:mm" (e.g.
"2011-01-19 12:17").
-version
Display version number and exits.
-help Print a brief help message and exits.
-manual Prints the manual page and exits.
-debug Display the SOAP messages exchanged.
EXAMPLES
ecaccess-event-send 167 2000
Trigger the event 167 with a sequence number of 2000.
ecaccess-event-send -delay 1d 167 2000
Trigger the same event as in the previous example in 24 hours.
SEE ALSO
ecaccess-event-grant, ecaccess-event-clear, ecaccess-event-list, ecaccess-event-delete, ecaccess-event-create and ecaccess.
perl v5.14.2 2012-04-16 ECACCESS-EVENT-SEND(1p)