I tried with the same code by giving the exact path for funct.sh. Now that error not found [No such file or directory got rectified but it's not connecting with Oracle and not executing the proc. Moreover am getting email message that No Duplicate records Found: though the result of this query fetches 800 records.
Also I tried with other version of code with your suggested changes and got the error message like this
hai,
can anybody say how to call or to execute an oracle stored procedure in oracle from unix...
thanks in advance.... for ur reply....
by,
leo (2 Replies)
Hi ,
i have created an .sh file that has the following code:
#!/bin/ksh
sqlplus -s p1istuat/p1istuat@CWS_IST6 @Procedure_Execute.sql &
sqlplus -s p1istuat/p1istuat@CWS_IST6 << EOF
exit
EOF
The mentioned Procedure_Execute.sql file inside has the following code:
exec TEST;
... (5 Replies)
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)
Hi everyone!
I'm new with Shell Scripting, and I have to do a shell script to call a procedure, which have 2 input parameters, the directory(from server) and the txt file (which have informations to update/insert in DB).
I have to create a shell script to execute that procedure for each txt... (5 Replies)
Hi Gurus,
Want to execute a shell script from a oracle procedure and get the status of the same, any assistance in this regard will be appreciated.
proc_data.sh is script name which I want to execute from oracle procedure
It should work something like below
procedure test
begin... (1 Reply)
i have the following code inside a shell script .prog in oracle server when i call the program
DBMS_OUTPUT.PUT_LINE(x_return_status|| ln_rep_req_id);
will return 0 , it is very strange , i try to submit the concurrent request in oracle , and it can successfully executed, what am i missing ? i... (1 Reply)
Hi ,
I am trying to automate a gather stats in shell script
#!/usr/bin/ksh
export ORACLE_HOME=/orcl/app/oracle/product/11.2.0.1/db_1
export PATH="$PATH:$ORACLE_HOME/bin"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib32"
export TNS_ADMIN=/opt/netprobe/config... (1 Reply)
Discussion started by: neil.k
1 Replies
LEARN ABOUT ULTRIX
invcutter
invcutter(1) General Commands Manual invcutter(1)Name
invcutter - generate subset inventory files
Syntax
/usr/sys/dist/invcutter [ -d ] [ -f root-path ] [ -f version-code ]
Description
The command reads master inventory records from standard input. A subset inventory record is written to standard output for every record
read from the input. The information contained in the output record is derived from the input record and the file attribute information in
the file hierarchy rooted in the current directory.
Options-d Enable debugging. No useful diagnostics are printed.
-f root-path Specify an alternate root path for finding file attribute information.
-v version-code Specify a 3-digit version code for use in the version field of the output records. The default version code is 010.
Restrictions
All input records must be sorted in ascending order on the pathname field.
Files described in an input record which exist as sockets in the file hierarchy are not processable.
If a file is described in an input record has a link count greater than 1, all other links to the file must be represented in the input.
Examples
The following command will generate inventory records for the master inventory entries in PDS020.mi containing version fields set to 020:
invcutter -v 020 < PDS020.mi
Return Values
An exit status of 0 is returned if all goes well. An exit status of 1 is returned if an error occurs. See Diagnostics.
Diagnostics
"cannot chdir to pathname (error-message)"
The program cannot change directories to the pathname directory specified with the -f option. The error-message will provide additional
information.
"sort error, record #n"
The nth input record is not in the correct sort order. All input records must be in ascending ASCII colating sequence on the pathname
field.
"cannot stat filename (error-message)"
An error has occurred attempting to read the attributes of filename. The error-message explains exactly what happened.
"pathname: illegal file type code 0140000"
The file pathname is a socket. Sockets are not supported as valid file types for distribution.
"unresolved nlink n: pathname"
This indicates that file pathname in the master inventory is linked to n files which do not appear in the master inventory. Check inventory
for validity with the program.
"n unresolved hard links"
This is an informational message stating how many files were detected in the input inventory which had unresolved links.
See Alsonewinv(1), stl_inv(5), stl_mi(5)
Guide to Preparing Software for Distribution on ULTRIX Systems
invcutter(1)