Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Trouble calling sqlplus within script Post 303045415 by SIMMS7400 on Friday 20th of March 2020 05:04:23 AM
Old 03-20-2020
HI Rudi - That doesn't work, unfortunately. I'll keep playing around with it
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

calling sqlplus from shell

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

calling sqlplus from within a for loop

i'm not new to programming, but i AM new to unix scripting. here's my deal. this works: #!/bin/ksh echo "HELLO" /oracle_home/bin/sqlplus username/password@MYDB<<EOF SELECT COUNT(*) FROM EMPLOYEES; EOF exit echo "GOODBYE" this doesn't: #!/bin/ksh echo "HELLO" for x in 1 2... (4 Replies)
Discussion started by: akosz
4 Replies

3. Shell Programming and Scripting

calling sqlplus, read table return etc

I have korn shell scripts. I want to pass a variable to a script which will execute a a sql script to read a table that contains env. variables. I want to read and then somehow export at unix level variables example for every row selected from the table build export command line field1... (5 Replies)
Discussion started by: TimHortons
5 Replies

4. Shell Programming and Scripting

Help supressing spool output from screen when calling sqlplus from script

I'm calling an embedded sql from my shell script file. This sql does simple task of spooling out the contents of the table (see below my sample code) into a spool file that I specify. So far so good, but the problem is that the output is also displayed on screen which I do NOT want. How can I... (3 Replies)
Discussion started by: MxC
3 Replies

5. UNIX for Dummies Questions & Answers

calling a unix shell script from sqlplus

I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible? if yes just give me an example for doing that. (2 Replies)
Discussion started by: boopathyvasagam
2 Replies

6. Shell Programming and Scripting

Control not returning from Sqlplus to calling UNIX shell script.

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

7. Shell Programming and Scripting

Control not returning from Sqlplus to calling UNIX shell script.

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

8. Shell Programming and Scripting

Oracle/SQLPlus help - ksh Script calling .sql file not 'pausing' at ACCEPT, can't figure out why

Hi, I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop. The first SQL file is basically a connection test and it is supposed to sort... (2 Replies)
Discussion started by: newbie_01
2 Replies

9. Shell Programming and Scripting

Avoid $ symbol while calling sqlplus in shellscript.

Hi All, we have requirement, i am created a shell script , inside i am connecting sqlplus and execute the query. below my code for your reference. get_sqlid () { sqlid=$( sqlplus -s $PBDW_USERID/$PBDW_PW@$PBDW_SID <<EOF DEFINE TBLNAME=$1 set feedback off set serverout on size... (4 Replies)
Discussion started by: KK230689
4 Replies

10. UNIX for Beginners Questions & Answers

SQLPLUS calling Via Script

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
pods::SDL::Mixer::Channels(3pm) 			User Contributed Perl Documentation			   pods::SDL::Mixer::Channels(3pm)

NAME
SDL::Mixer::Channels -- SDL::Mixer channel functions and bindings CATEGORY
Mixer DESCRIPTION
METHODS
allocate_channels my $ret = SDL::Mixer::Channels::allocate_channels( $number_of_channels ); Dynamically change the number of channels managed by the mixer. If decreasing the number of channels, the upper channels are stopped. This function returns the new number of allocated channels. Example use SDL::Mixer::Channels; printf("We got %d channels! ", SDL::Mixer::Channels::allocate_channels( 8 ) ); volume my $prev_volume = SDL::Mixer::Channels::volume( $channel_number, $volume ); "volume" changes the volume of the channel specified in channel by the amount set in volume. The range of volume is from 0 to "MIX_MAX_VOLUME" which is 128. Passing "-1" to channel will change the volume of all channels. If the specified volume is "-1", it will just return the current volume. Returns the previously set volume of the channel. play_channel my $channel_number = SDL::Mixer::Channels::play_channel( $channel, $chunk, $loops ); "play_channel" will play the specified "chunk" over the specified "channel". SDL_mixer will choose a channel for you if you pass "-1" for "channel". The chunk will be looped "loops" times, the total number of times played will be "loops+1". Passing "-1" will loop the chunk infinitely. Returns the channel the chunk will be played on, or "-1" on error. Example: use SDL::Mixer; use SDL::Mixer::Channels; use SDL::Mixer::Samples; SDL::init(SDL_INIT_AUDIO); SDL::Mixer::open_audio( 44100, SDL::Constants::AUDIO_S16, 2, 4096 ); my $chunk = SDL::Mixer::Samples::load_WAV('sample.wav'); SDL::Mixer::Channels::play_channel( -1, $chunk, -1 ); SDL::delay(1000); SDL::Mixer::close_audio(); play_channel_timed my $channel = SDL::Mixer::Channels::play_channel_timed( $channel, $chunk, $loops, $ticks ); Same as play_channel but you can specify the time it will play by $ticks. fade_in_channel my $channel = SDL::Mixer::Channels::fade_in_channel( $channel, $chunk, $loops, $ms ); Same as play_channel but you can specify the fade-in time by $ms. fade_in_channel_timed my $channel = SDL::Mixer::Channels::fade_in_channel_timed( $channel, $chunk, $loops, $ms, $ticks ); Same as fade_in_channel but you can specify the time how long the chunk will be played by $ticks. pause SDL::Mixer::Channels::pause( $channel ); Pauses the given channel or all by passing "-1". resume SDL::Mixer::Channels::resume( $channel ); Resumes the given channel or all by passing "-1". halt_channel SDL::Mixer::Channels::halt_channel( $channel ); Stops the given channel or all by passing "-1". expire_channel my $channels = SDL::Mixer::Channels::expire_channel( $channel, $ticks ); Stops the given channel (or "-1" for all) after the time specified by $ticks (in milliseconds). Returns the number of affected channels. fade_out_channel my $fading_channels = SDL::Mixer::Channels::fade_out_channel( $which, $ms ); "fade_out_channel" fades out a channel specified in "which" with a duration specified in "ms" in milliseconds. Returns the the number of channels that will be faded out. channel_finished SDL::Mixer::Channels::channel_finished( $callback ); Add your own callback when a channel has finished playing. "NULL" to disable callback. The callback may be called from the mixer's audio callback or it could be called as a result of halt_channel, etc. do not call "lock_audio" from this callback; you will either be inside the audio callback, or SDL_mixer will explicitly lock the audio before calling your callback. Example 1: my $callback = sub{ printf("[channel_finished] callback called for channel %d ", shift); }; SDL::Mixer::Channels::channel_finished( $callback ); Example 2: sub callback { ... } SDL::Mixer::Channels::channel_finished( &callback ); playing my $playing = SDL::Mixer::Channels::playing( $channel ); Returns 1 if the given channel is playing sound, otherwise 0. It doesn't check if the channel is paused. Note: If you pass "-1" you will get the number of playing channels. paused my $paused = SDL::Mixer::Channels::paused( $channel ); Returns 1 if the given channel is paused, otherwise 0. Note: If you pass "-1" you will get the number of paused channels. fading_channel my $fading_channel = SDL::Mixer::Channels::fading_channel( $channel ); Returns one of the following for the given channel: o MIX_NO_FADING o MIX_FADING_OUT o MIX_FADING_IN Note: Never pass "-1" to this function! get_chunk my $chunk = SDL::Mixer::Channels::get_chunk( $channel ); "get_chunk" gets the most recent sample chunk played on channel. This chunk may be currently playing, or just the last used. Note: Never pass "-1" to this function! AUTHORS
See "AUTHORS" in SDL. perl v5.14.2 2012-05-28 pods::SDL::Mixer::Channels(3pm)
All times are GMT -4. The time now is 08:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy