The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com



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
Execute PL/SQL function from Unix script (.sql file) reptile UNIX for Dummies Questions & Answers 1 05-14-2009 07:40 AM
Execute .dat file from a shell script user9526 Shell Programming and Scripting 2 05-13-2009 11:58 AM
(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script praka Shell Programming and Scripting 6 04-15-2009 06:09 AM
Want to execute rest of the script after the file is ready ... csaha Shell Programming and Scripting 5 09-25-2006 04:04 AM
How to execute a .sql file with shell script abuanas Shell Programming and Scripting 2 04-26-2006 04:16 AM

Reply
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 07-01-2009
Dan27 Dan27 is offline
Registered User
  
 

Join Date: Jul 2009
Posts: 1
Creating a .sh script to execute an SQL file

Hello

I'm hoping someone may be able to help. I'm absolutely brand new to these shell scripts and have tried to bash bits together from the little learnt but my final script still doesn't work. Sorry if something similar is already posted but couldn't find anything existing close enough to help me with what I need.

The .sh is running from an external application and displays the following error meesage Unable to execute 'filepath' 2>&1. Does this error message relate to anything specific or anything anyone is aware of?

All I require the .sh to do is execute 1 SQL file called unique.sql and the SQL code does everything else I need but still been unable to get it to work.

Thanks in advance
  #2 (permalink)  
Old 07-01-2009
guruprasadpr guruprasadpr is offline
Registered User
  
 

Join Date: Jun 2009
Posts: 8
to run a sql file from a script, the following line should do:

sqlplus -s user/password@inst @unique.sql
Sponsored Links
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 07:22 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language translation by Google.
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0