Sponsored Content
Top Forums Shell Programming and Scripting How to write CLOB parameter in a file or XML using shell script? Post 302584288 by BeefStu on Thursday 22nd of December 2011 03:34:43 PM
Old 12-22-2011
Invoke sqlplus and play with these parameters

Code:
 
set long ...
set longchunksize ...
set linesize ...

Hope this helps
This User Gave Thanks to BeefStu For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

parameter file for a shell script

Hi I was able to pass parameters to a shell script from the command line but now, I am trying to make the shell script to get those parameters/values from a file. Please give me ideas how to do this or if you have an example or website that shows how to do this. I tried searches but it... (2 Replies)
Discussion started by: bryan
2 Replies

2. Shell Programming and Scripting

How to remove xml namespace from xml file using shell script?

I have an xml file: <AutoData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Table1> <Data1 10 </Data1> <Data2 20 </Data2> <Data3 40 </Data3> <Table1> </AutoData> and I have to remove the portion xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" only. I tried using sed... (10 Replies)
Discussion started by: Gary1978
10 Replies

3. Shell Programming and Scripting

Passing parameter from one file to shell script

Hi All, I have a 2 files. File1 i am generating using an ETL tool, which is a comman seperated delimited file which contains country code & load date. everytime, this country code will be updated from a table. It might be AB or BA & ld_date will be for which date we need to load the file. ... (7 Replies)
Discussion started by: Amit.Sagpariya
7 Replies

4. Programming

Could't pass clob from my shell script

Hello Everyone, I am trying to write a shell script that will read from a file and will call a pl/sql procedure that takes clob as input. Now as varchar2 has a limit much less than clob so i can't just pass the input as in one variable.(size may be >32K). This is what i tried. Not posting the... (0 Replies)
Discussion started by: mayukh.banerjee
0 Replies

5. Shell Programming and Scripting

Fetching CLOB value from oracle into shell script

Hi, Can anybody let me know how i can achieve the below output. I have a select query which selects two columns. I need to spool the value into a dat file for each row that is returned from the query with the coulumn1 as the name of the dat file . ex: column1: location_id column2:... (1 Reply)
Discussion started by: justchill
1 Replies

6. Shell Programming and Scripting

How to call stored procedure with CLOB out parameter from shell script?

I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)
Discussion started by: vel4ever
0 Replies

7. Shell Programming and Scripting

Read parameter file for a shell script

Hi All, I need urgent Help from all of you here. Below is my code- ================================================== #!/usr/bin/sh cd $1 cat $2 | tr -ds "$" "" > parameter_file.param export `parameter_file.param` chmod 777 parameter_file.param echo $1 echo $2 cd $prmDirInput... (5 Replies)
Discussion started by: Amit786
5 Replies

8. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (2 Replies)
Discussion started by: Debalina Roy
2 Replies

9. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (3 Replies)
Discussion started by: Debalina Roy
3 Replies

10. Programming

How to write in other language in text/xml file by reading english text/xml file using C++?

Hello Team, I have 2 files.one contains english text and another contains Japanese. so i have to read english text and replace the text with Japanesh text in third file. Basically, I need a help to write japanese language in text/xml file.I heard wstring does this.Not sure how do i write... (2 Replies)
Discussion started by: SA_Palani
2 Replies
play(1) 						      General Commands Manual							   play(1)

NAME
play - play any sound file to audio device rec - record audio to any sound file format SYNOPSIS
play [fopts] infile [effect] rec [fopts] outfile [effect] DESCRIPTION
This manual page briefly documents the play and rec commands. play and rec are programs that allow you to play and record different types of sound files from the command line. They are front ends to the more general sox(1) package. Normally, the play command will automatically detect the type and other parameters of the soundfile. If it can't do so, the parameters can be changed through options. OPTIONS
A summary of common options are included below. For a complete description of options and their values, see the sox(1) man page. -c [channels], --channels=[channels] Define the number of channels in the file. -d [device], --device=[device] Specify a different device to play the sound file to. -f [format], --format=[format] Specify bit format of the sample. One of s, u, U, A, a, or g. -r [rate], --rate=[rate] Specify the sample rate of the audio data (samples per second). -s [size], --size=[size] Specify the width of each sample. One of b, w, l, f, d, or D. -t [type], --type=[type] Specify audio file format to use. Useful if it can not be automatically determined. -v [volume], --volume=[volume] Change the audio volume -x , --xinu Reverse the byte order of the sample (only works with 16 and 32-bit data). -h, --help Show summary of options. --version Show version of play/rec. Description of effects are described in the sox(1) man page. SEE ALSO
sox(1) soxexam(1) AUTHOR
This manual page was written by Guenter Geiger <geiger@iem.mhsg.ac.at>, for the Debian GNU/Linux system. Updates by Anonymous. December 11, 2001 play(1)
All times are GMT -4. The time now is 01:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy