01-16-2015
Will the other users use the ksh script or will they access the database via other tools?
If the users access the database via other tools: is it enough to display the results so the users can redirect the output to a file (like in your example where the script takes care of storing the results)?
Your current package will throw ora-01403 if the query does not return any rows and ora-01422 if it returns more than 1 row.
This User Gave Thanks to cero For This Post:
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am using sqlplus.
I have the stored procedure name.
How can i print the stored procedure content? (2 Replies)
Discussion started by: kamil
2 Replies
2. Shell Programming and Scripting
Here is a snippet of my code:
if
then
echo "\n Deleting all reports older than 24 hours. \n" >> $logfile
ls -l $FileName >> $logfile
... (1 Reply)
Discussion started by: mh53j_fe
1 Replies
3. Shell Programming and Scripting
Is it possible to pass unix shell arrays in Oracle stored procedure?
Is yes, how?
Thanks (6 Replies)
Discussion started by: superprogrammer
6 Replies
4. Shell Programming and Scripting
Hi
I have a stored procedure which should be called from KSH.
Could ayone please help me with this.
Thanks (1 Reply)
Discussion started by: BlAhEr
1 Replies
5. Shell Programming and Scripting
Here's a shell script snippet.....
cd $ORACLE_HOME/bin
Retval=`sqlplus -s <<eof
$TPDB_USER/april@$TPD_DBCONN
whenever SQLERROR exit 2 rollback
whenever OSERROR exit 3 rollback
set serveroutput on
set pages 999
var status_desc char(200)
var status_code... (1 Reply)
Discussion started by: hidnana
1 Replies
6. Shell Programming and Scripting
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
Thanks
barani (6 Replies)
Discussion started by: barani75
6 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
Hi,
Can you assist me in how to redirect the output of oracle stored procedure from unix script?
Something similar to what i did for sybase
isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %%
proc_my_test 8
go
%%
Thanks in advance - jak (0 Replies)
Discussion started by: jakSun8
0 Replies
9. 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
10. Shell Programming and Scripting
Friends,
I'm newbie with ksh so wanting some help....
1. I'm trying to call oracle stored procedure from ksh script by taking variable value from runtime, feed into script and execute procedure.
2. Put name1 and name2 value from script run replacing $3 & $4
I'm trying to put name1 in... (4 Replies)
Discussion started by: homer4all
4 Replies
LEARN ABOUT CENTOS
svnserve.conf
svnserve.conf(5) File Formats Manual svnserve.conf(5)
NAME
svnserve.conf - Repository configuration file for svnserve
SYNOPSIS
repository-path/conf/svnserve.conf
DESCRIPTION
svnserve.conf controls the behavior of the svnserve daemon on a per-repository basis. It is located in the conf subdirectory of the repos-
itory.
The overall structure of the file is the same as the structure of Subversion user configuration files. At the top level are sections,
which are specified by words in square brackets; inside each section are variable definitions of the form "variable = value". Lines begin-
ning with '#' are ignored. svnserve.conf currently uses only one section named "general", and supports the following variables:
anon-access = none|read|write
Determines the access level for unauthenticated users. write access allows all repository operations. read access allows all opera-
tions except committing and changing revision properties. none access allows no access. The default level is read.
auth-access = none|read|write
Determines the access level for authenticated users, using the same access levels as above. The default level is write.
password-db = filename
Sets the location of the password database. filename may be relative to the repository conf directory. There is no default value.
The password database has the same overall format as this file. It uses only one section "users"; each variable within the section is
a username, and each value is a password.
authz-db = filename
The authz-db option controls the location of the authorization rules for path-based access control. filename may be relative to the
repository conf directory. There is no default value. If you don't specify an authz-db, no path-based access control is done.
realm = realm-name
Sets the authentication realm of the repository. If two repositories have the same password database, they should have the same
realm, and vice versa; this association allows clients to use a single cached password for several repositories. The default realm
value is the repository's uuid.
EXAMPLE
The following example svnserve.conf allows read access for authenticated users, no access for anonymous users, points to a passwd database
in the same directory, and defines a realm name.
[general]
anon-access = none
auth-access = read
password-db = passwd
realm = My First Repository
The file "passwd" would look like:
[users]
joeuser = joepassword
jayrandom = randomjay
SEE ALSO
svnserve(8)
svnserve.conf(5)