Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to send data to previous program (pipe)?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to send data to previous program (pipe)?
# 22  
Old 03-16-2018
Give us a break. The sqlplus utility made by Oracle Corporation is a utility that reads a script of database query requests to be fed to an Oracle database engine. You supply the script that sqlplus will be interpreting while sqlplus is running.

If you're saying that you hired Oracle Corporation to write the script that you are using and that the requirements of what you want that script to do were incorrectly specified or that the requirements have changed, you need to negotiate with Oracle to modify that script for you.

We certainly can't write an sqlplus script for you that will correct the behavior of your current script if you:
  1. don't show us your current script,
  2. don't explain to us what the script is currently doing, and
  3. don't explain exactly what you want it to do differently.
# 23  
Old 03-26-2018
Quote:
Originally Posted by Don Cragun
If you're saying that you hired Oracle Corporation to write the script that you are using and that the requirements of what you want that script to do were incorrectly specified or that the requirements have changed, you need to negotiate with Oracle to modify that script for you.
I am not telling that.
My case isthat... if within sqlplus an user is executing a command:
Code:
ALTER SESSION set container='new_container';

then I'd like the sqlplus to automatically execute command to change sqlprompt just after the user's command is completed. That's all my requirements. I don't have any sql script.
# 24  
Old 03-26-2018
Change it to what?
# 25  
Old 03-26-2018
Quote:
Originally Posted by JackK
I am not telling that.
My case isthat... if within sqlplus an user is executing a command:
Code:
ALTER SESSION set container='new_container';

then I'd like the sqlplus to automatically execute command to change sqlprompt just after the user's command is completed. That's all my requirements. I don't have any sql script.
Of course you have an SQL script: The SQL command:
Code:
ALTER SESSION set container='new_container';

is one line in that SQL script. All of the commands being processed by the sqlplus command you are invoking constitute an SQL script!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

RWSocket::send: Broken pipe Error in /var/adm/messages

Hi Guys, I am getting some strange error in /var/adm/messages in my Solaris 10 box with Veritas Cluster and EMC storage. bash-3.00$ cat /var/adm/messages | egrep -v "lw8|snmp|sshd|xntpd|kern.info|LOGIN|link|service|started|finished|repeated|SS7 Log-daemon|success" Dec 18 09:58:35 GAMMa2... (1 Reply)
Discussion started by: vivek.goel.piet
1 Replies

2. Shell Programming and Scripting

Perl to send previous and current value

For example, I have a file called number.txt. x y 1 1 2 4 3 9 4 6 5 5 6 6 7 9 8 4 9 1 10 0 ... And I want to print out the value of x and y, if y%4==0 and the next value of y%4==0. Thus, the sample output is: 1 1 *because the previous x before 2 is 1 2 4 *because 4%4 == 0 7 9... (2 Replies)
Discussion started by: Tzeronone
2 Replies

3. Linux

Perl program to print previous set of lines once a pattern is matched

Hi all, I have a text data file. My aim here is to find line called *FIELD* AV for every record and print lines after that till *FIELD* RF. But here I want first 3 to four lines for very record as well. FIELD AV is some where in between for very record. SO I am not sure how to retrieve lines in... (2 Replies)
Discussion started by: kaav06
2 Replies

4. UNIX for Advanced & Expert Users

sftp error:- Couldn't send packet: Broken pipe

Hi, I am trying to sftp a large file(appx. 2 GB size) from solaris 10 to a Linux server. While sftping(with no options), connection is terminated after some time with broken pipe error. sftp with option -R1 or -B1500 is successful. Linux server ssh Version: OpenSSH_3.9p1, OpenSSL 0.9.7a... (3 Replies)
Discussion started by: brij123
3 Replies

5. Homework & Coursework Questions

pipe program in C

Hello guys, my professor give me 2 days to study and make a program usign pipe, fork in c i need to do a program read a arq.txt the father process read the file and the child print ! 2. Relevant commands, code, scripts, algorithms: like this Code: #include <stdio.h>... (1 Reply)
Discussion started by: beandj
1 Replies

6. Programming

pipe program in C

Hello guys, my professor give me 2 days to study and make a program usign pipe, fork in c i need to do a program read a arq.txt the father process read the file and the child print ! like this #include <stdio.h> #include <stdlib.h> #include <sys/wait.h> int main (){ ... (1 Reply)
Discussion started by: beandj
1 Replies

7. Solaris

sendmail pipe to a program.

Hello, I recently upgraded our server from Solaris 8 to 9. The sendmail is unabled to pipe the email to a perl script. I can send and received email to local and external mail, but the script did not get the email. There is no error in the log and I could not find any thing on the web. Here... (0 Replies)
Discussion started by: ld98
0 Replies

8. Shell Programming and Scripting

Writing a program to receive the GPS data and send to other server

Hi, I would like to write a program to receive the GPS data and then send the data via network to other program. All of the program is not write yet(include host and sender) All of the server OS is unix or linux Could you mind to give me some idea to do this? Thanks so much! Ken ... (2 Replies)
Discussion started by: kenlok
2 Replies

9. UNIX for Dummies Questions & Answers

Script to open program and send/execute command in program

Hi, i want to write a script that executes a program (exec?) . this program then requires a filename as input. how do i give it this input in the script so the program will be complete run and close by the script. e.g. exec prog.exe program then asks for filename "enter filename:"... (1 Reply)
Discussion started by: tuathan
1 Replies

10. Programming

C++ How to use pipe() & fork() with stdin and stdout to another program

Hi, Program A: uses pipe() I am able to read the stdout of PROGAM B (stdout got through system() command) into PROGRAM A using: * child -> dup2(fd, STDOUT_FILENO); -> execl("/path/PROGRAM B", "PROGRAM B", NULL); * parent -> char line; -> read(fd, line, 100); Question:... (2 Replies)
Discussion started by: vvaidyan
2 Replies
Login or Register to Ask a Question