11-24-2010
Maybe you can have a look at this
link
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am executing the following code :-
sqlplus -s ${DATABASE_USER} |&
print -p -- 'set feed off pause off pages 0 head off veri off line 500'
print -p -- 'set term off time off serveroutput on size 1000000'
print -p -- "set sqlprompt ''"
print -p -- "SELECT run_command from... (2 Replies)
Discussion started by: suds19
2 Replies
2. Shell Programming and Scripting
Unix Gurus,
I have been breaking my head to get this done..seems simple..
I need to read a flat file and based on a key word in a line, i need to skip the previous 3 lines.
eg :
Line1
Line2
Line3
Line4
Line5
Line6
Error
Line7
Line8
Line9
Error
Line10 (4 Replies)
Discussion started by: ravred
4 Replies
3. Shell Programming and Scripting
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies
4. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
5. Shell Programming and Scripting
Hi,
I am facing the following error in calling the stored procedure from SQLPLUS in unix environment.
SQL> set serveroutput on
SQL> var store number;
SQL> exec test_proc(:store, 200);
BEGIN TEST_PROC(:store, 200); END;
*
ERROR at line 1:
ORA-01858: a non-numeric character was found... (8 Replies)
Discussion started by: pradeep7986
8 Replies
6. Shell Programming and Scripting
Hi all,
I am using the below given sqlplus command in my unix script to invoke a stored procedure which returns a value .It works fine.
RET_CODE=$(/opt/oracle/product/10.2.0.4.CL/bin/sqlplus -S $USER/$PASSWD@$DB_NAME <<EOF
EXEC MY_PKG.MY_SP (:COUNT);
PRINT COUNT;
commit;
... (6 Replies)
Discussion started by: Shri123
6 Replies
7. Shell Programming and Scripting
Hi,
I am facing an issue wherein some temporary files (here docs) are getting created in /tmp and are not getting deleted automatically.
When i check the list of open files with below command i can see one file is getting appended continuously.(In this case /tmp/sfe7h.34p)
The output is... (4 Replies)
Discussion started by: Navin_Ramdhami
4 Replies
8. Shell Programming and Scripting
Hello All,
I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below.
cat > $v_Input_File 2>>$v_Log << EOF
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16';
EXECUTE... (1 Reply)
Discussion started by: vikas_trl
1 Replies
9. Shell Programming and Scripting
Hello All,
I have exactly same issue @vikas_trl had in following link:
https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would... (4 Replies)
Discussion started by: RicardoQ
4 Replies
10. UNIX for Beginners Questions & Answers
Hello All,
Could you please help me if i am doing anything wrong in below script, especially the sqlplus part performance wise or anything else i could improvise in the script. Thank you.
#!/bin/ksh
## Batch Obj Id
MP_BCH_OBJ_ID=$1
PASS=$2
partition=$3
## script dir... (6 Replies)
Discussion started by: Ariean
6 Replies
LEARN ABOUT NETBSD
icecream
ICECREAM(1) icecream ICECREAM(1)
NAME
icecream - download icecast and shoutcast streams, redirecting all fetched content to stdout and/or to disk at the same time
SYNOPSIS
icecream [OPTIONS] URL [URL..]
DESCRIPTION
icecream is a lightweight, non-interactive, stream download utility. It connects to icecast and shoutcast servers or direct stream URLs,
and redirects all fetched content to stdout and/or to media files on your disk.
Listen to the stream piping the output to a stdin-capable media player. Save the stream to a named file or split it into different tracks.
It is possible to redirect the stream and save it to disk at the same time.
icecream is able to parse pls and m3u playlists, and to download mp3 and ogg direct stream URLs. If the stream is anonymous it will be
saved as 'stream-time.mp3', where time is actual timestamp.
OPTIONS
-h, --help
Print a help message describing all options
-q, --quiet
Turn off output
-v, --verbose
Be verbose
-t, --tracks
Split stream into tracks (if possible)
--name=NAME
Save the stream to file specified by NAME. Format codes starting with "%" will be replaced. See the date command for valid format
codes.
--stop=N[units]
Stop downloading the stream after N kb/mb/min/songs
--user-agent=AGENT
Set user-agent header to AGENT
--stdout
Output stream to stdout (implies -q)
--sync Turn syncing on, required for some mpeg players that read from stdin
--debug Turn on debugging outputs
EXAMPLES
Streaming to mpg123
icecream --stdout http://radio.com/playlist.pls | mpg123 -
Split stream into different tracks
icecream -t http://metal.org/radio.pls
Split stream into tracks and play with vlc at the same time
icecream -t --stdout http://streaming.com/playlist.pls | vlc file:/dev/stdin
Prepare a 74 minute CD
icecream -t --stop 74min http://trace.net/playlist.m3u
Use a filename with today's date as output
icecream -q --name 'radio_%Y_%m_%d' --stop 60min http://radio.com/playlist.pls
BUGS
You are welcome to send bug reports about icecream to our mailing list. Feel free to visit http://icecream.sourceforge.net
AUTHOR
Written by Gil Megidish <gil at megidish.net>
1.3 2008-04-28 ICECREAM(1)