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
mono-asp-apps(1) User Commands mono-asp-apps(1)
NAME
mono-asp-apps - utility to manage ASP.NET 2.0 applications installed from RPMs
SYNOPSIS
mono-asp-apps command [options]
DESCRIPTION
The 'mono-asp-apps' command is useful on systems which install applications from RPM packages and when the RPM packages have been created
according to the Mono RPM packaging guidelines for ASP.NET applications.
The utility allows one to initialize, enable, disable and start installed applications. Note that you do not use this utility to manage
applications hosted and managed by the Apache (or other) web server, only by xsp.
Note that this utility is useful only on systems where at least one application packaged according to the Mono ASP.NET 2.0 RPM packaging
guidelines has been installed.
COMMANDS
The commands which take an application name, require the it to be one of the registered names. See the `list` command below.
init APPLICATION_NAME
Initializes the application named APPLICATION_NAME, if it hasn't been done already. Initialization actions performed are applica-
tion specific, but may include creating databases and populating them, creating directories, downloading files etc.
enable APPLICATION_NAME
Enables APPLICATION_NAME for automatic start when XSP is started as part of the system bootup process.
disable APPLICATION_NAME
Disables APPLICATION_NAME, so that it is not started automatically when XSP is started as part of the system bootup process.
start APPLICATION_NAME [server_options]
Manually starts the xsp2 process passing the configuration of APPLICATION_NAME to the xsp2 process. Applications may ship with a
bundled start script which will be used instead of xsp2 if present. server_options are passed verbatim to the server process.
list Lists all the applications known to the utility.
AUTHORS
Marek Habersack <mhabersack@novell.com>
SEE ALSO
xsp(1)
MORE INFORMATION
The Mono project (http://www.go-mono.com) is a collaborative effort led by Novell (http://www.novell.com) to implement an open source ver-
sion of the .NET Framework.
MAILING LISTS
Mailing lists are listed at the http://www.mono-project.com/Mailing_Lists
mono-asp-apps 2.6.4 31 Oct 2007 mono-asp-apps(1)