|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Running shell scripts from web browser | corleone | Shell Programming and Scripting | 7 | 08-01-2006 12:11 AM |
| unix shell scripts for running on solaris | srini_ibmadmin | UNIX for Advanced & Expert Users | 3 | 06-07-2006 04:28 AM |
| running vendor shell scripts | Javagate | UNIX for Dummies Questions & Answers | 1 | 04-13-2004 03:07 PM |
| Running shell scripts on a remote server | pepintheshort | UNIX for Dummies Questions & Answers | 2 | 07-22-2003 05:20 PM |
| Cron running shell scripts. | cfoxwell | UNIX for Dummies Questions & Answers | 3 | 09-26-2001 12:35 PM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
06-28-2006
|
||||
|
||||
Running SQL Scripts from Shell script - Need insight!
I've a script that fetches various values from the database as below:
#! /bin/ksh $conn="user/pwd@service_name" `sqlplus -s << $conn EOF1 @xyz.sql @pqr.sql @abc.sql EOF1` The output of the script should generate txt files containing the results from queries which are further manipulated for display / reporting. However, when the scripts executes, Oracle throws an exception SP-0734 : not found .. as against running a direct query within the HERE docs (<< EOF1 EOF1). The same exception doesn't arise when the entire block is assigned to a return variable. Can someone focus on why this shows up? TIA Sirisha |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
