02-01-2011
@Scrutinizer
thank you ...its working fine...my issue resolved once spaces are removed
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: amitkr
2 Replies
2. UNIX for Advanced & Expert Users
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)
Discussion started by: ganapati
2 Replies
3. Solaris
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)
Discussion started by: m9dhatter
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: MadMage
7 Replies
5. Shell Programming and Scripting
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)
Discussion started by: bashN00b
3 Replies
6. Shell Programming and Scripting
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)
Discussion started by: desibabu
7 Replies
7. AIX
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)
Discussion started by: Chapel
3 Replies
8. Shell Programming and Scripting
Hello,
This is my first post and I would be very thankful if you can help me. I've already searched in the forum and I've found a very similar thread in wich my problem is solved, but the thread is closed and the solution given in it doesn't work in my shell:
153194-problem-quitting-sqlplus
... (11 Replies)
Discussion started by: JuanPerez
11 Replies
9. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
10. UNIX and Linux Applications
Hi all,
i face an error related to my server ""it's running server"" when i use sqlplus command
$ sqlplus
bash: sqlplus: command not found
the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup.
i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies
LEARN ABOUT OSX
svk::command::status
SVK::Command::Status(3) User Contributed Perl Documentation SVK::Command::Status(3)
NAME
SVK::Command::Status - Display the status of items in the checkout copy
SYNOPSIS
status [PATH..]
OPTIONS
-q [--quiet] : do not display files not under version control
--no-ignore : disregard default and svn:ignore property ignores
-N [--non-recursive] : do not descend recursively
-v [--verbose] : print full revision information on every item
DESCRIPTION
Show pending changes in the checkout copy.
The first three columns in the output are each one character wide:
First column, says if item was added, deleted, or otherwise changed:
' ' no modifications
'A' Added
'C' Conflicted
'D' Deleted
'I' Ignored
'M' Modified
'R' Replaced
'?' item is not under version control
'!' item is missing (removed by non-svk command) or incomplete
'~' versioned item obstructed by some item of a different kind
Second column, modifications of a file's or directory's properties:
' ' no modifications
'C' Conflicted
'M' Modified
Third column, scheduled commit will contain addition-with-history
' ' no history scheduled with commit
'+' history scheduled with commit
Remaining fields are variable width and delimited by spaces:
The working revision (with -v)
The last committed revision and last committed author (with -v)
The working copy path is always the final field, so it can include spaces.
Example output:
svk status
M bar.c
A + qax.c
svk status --verbose wc
M 53 2 sally wc/bar.c
53 51 harry wc/foo.c
A + - ? ? wc/qax.c
53 43 harry wc/zig.c
53 20 sally wc
perl v5.10.0 2008-08-04 SVK::Command::Status(3)