Hi,
trying this
===============================
Temp=`sqlplus -s user/passwd <<EOF
WHENEVER SQLERROR EXIT 1
set serverout on
set feedback off
set heading off
select nam from tabel1
where x=y;
EOF`
echo Temp>>$logfile
=================================
The select statement is... (2 Replies)
Hi all,
Iam facing a lot of problem while calling Oracle 10g SQLPLUS files from shell.
What is the standard procedures to be taken care.
Any help would be useful for me.
Thanks in advance,
Ganapati. (2 Replies)
Ok. So I've finally compiled the latest version of GNU emacs on Solaris 5.8.
I've set putty up so that it sets TERM=xtermc. emacs now has syntax highlighting. The problem is, whenever I quit emacs, it changes the screen colors. The background is now the same as the color of the minibuffer. It... (1 Reply)
Hi my code looks like:
if test $STEP -le 10
then
.
.
ls -1d AM*-OUT|while read MYDIR
do
cd $MYDIR
ls |tail -n1| while read MYFILE
do
.
.
if test -s $MYFILE
then
sqlldr ....
rc=$?
if test $rc -ne 0 (3 Replies)
This is a very simple problem, I am wondering why I can find no answer anywhere...
I have a script that can be run either sourced or not. This script has some place where it needs to quit execution (e.g., when an error is found)
If I "exit", the sourced call would exit the parent shell, but... (7 Replies)
Folks,
Below is a basic synopsis of the problem. I have a script that I need to check for some env vars and fail (exit the script) if they are not there. At the same time I need to set some default env vars. To do this I must run the script from the parent shell or source the script. Doing... (3 Replies)
Hi all,
I have a scenario where im connecting to sqlplus executing a query,redirecting the output to a file and manipulating the file
MY CODE IS AS FOLLOWS
sqlplus -s /nolog << EOF > $UTILITIES_HOME/temp/analyze.temp.log &
set linesize 3000
set trimspool on
set pagesize... (2 Replies)
sql_rows=`sqlplus -s / <<EOF
set heading off
set pagesize 1000
set tab off
set linesize 120 wrap off
column "Path" format a15
--column "No_Of_files" format a10
select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files
... (7 Replies)
Hi guys,
Here is the error i get by running a "sqlplus -v" after installing an oracle client 10.2.0.5 on an AIX 5.3.9 server.
Could not load program sqlplus:
Symbol resolution failed for sqlplus because:
Symbol __pthread (number 307) is not exported from dependent
... (3 Replies)
Hi I am having a problem exiting a WHILE loop. I am on a Sun server using ksh.
I am running a Veritas Cluster Software (High Availablity) command to obtain a group status and grepping the command output for status "G" which means that the filesystem is frozen and therefore not available to... (3 Replies)
Discussion started by: bigbuk
3 Replies
LEARN ABOUT OPENSOLARIS
pthread_exit
pthread_exit(3C) Standard C Library Functions pthread_exit(3C)NAME
pthread_exit - terminate calling thread
SYNOPSIS
cc -mt [ flag... ] file... -lpthread [ library... ]
#include <pthread.h>
void pthread_exit(void *value_ptr);
DESCRIPTION
The pthread_exit() function terminates the calling thread, in a similar way that exit(3C) terminates the calling process. If the thread is
not detached, the exit status specified by value_ptr is made available to any successful join with the terminating thread. See
pthread_join(3C). Any cancellation cleanup handlers that have been pushed and not yet popped are popped in the reverse order that they were
pushed and then executed. After all cancellation cleanup handlers have been executed, if the thread has any thread-specific data, appropri-
ate destructor functions will be called in an unspecified order. Thread termination does not release any application visible process
resources, including, but not limited to, mutexes and file descriptors, nor does it perform any process level cleanup actions, including,
but not limited to, calling any atexit() routines that might exist.
An exiting thread runs with all signals blocked. All thread termination functions, including cancellation cleanup handlers and thread-spe-
cific data destructor functions, are called with all signals blocked.
An implicit call to pthread_exit() is made when a thread other than the thread in which main() was first invoked returns from the start
routine that was used to create it. The function's return value serves as the thread's exit status.
The behavior of pthread_exit() is undefined if called from a cancellation cleanup handler or destructor function that was invoked as a
result of either an implicit or explicit call to pthread_exit().
After a thread has terminated, the result of access to local (auto) variables of the thread is undefined. Thus, references to local vari-
ables of the exiting thread should not be used for the pthread_exit() value_ptr parameter value.
The process exits with an exit status of 0 after the last thread has been terminated. The behavior is as if the implementation called
exit() with a 0 argument at thread termination time.
RETURN VALUES
The pthread_exit() function cannot return to its caller.
ERRORS
No errors are defined.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Committed |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
|Standard |See standards(5). |
+-----------------------------+-----------------------------+
SEE ALSO exit(3C), pthread_cancel(3C), pthread_create(3C), pthread_join(3C), pthread_key_create(3C), attributes(5), standards(5)SunOS 5.11 2 Nov 2007 pthread_exit(3C)