Skip to ContentSkip to Footer
Start of content
- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - Linux
- >
- General
- >
- problem executing sql script
General
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
-
- Forums
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Blogs
-
Information
-
English
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-07-2003 02:16 AM
11-07-2003 02:16 AM
problem executing sql script
I am having problrm running script in sqlplus on unix 11:00 box
as an example
I have simple script saved in my home/scripts called whoami
ams i tried running at sqlplus probpt after logging in and got following error
I change the permission on the script as well.
SQL> @whoami
SP2-0310: unable to open file "whoami.sql"
SQL>
Help is appreciated.
as an example
I have simple script saved in my home/scripts called whoami
ams i tried running at sqlplus probpt after logging in and got following error
I change the permission on the script as well.
SQL> @whoami
SP2-0310: unable to open file "whoami.sql"
SQL>
Help is appreciated.
raj
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-07-2003 02:26 AM
11-07-2003 02:26 AM
Re: problem executing sql script
Cathi
SQLplus will look for scripts in your current directory, then in the directory pointed to by $SQLPATH, if set.
Extension should be .sql
It evidently can't find whoami.sql in either of these.
Did you cd into home/scripts before firing up sqlplus ?
-- Graham
SQLplus will look for scripts in your current directory, then in the directory pointed to by $SQLPATH, if set.
Extension should be .sql
It evidently can't find whoami.sql in either of these.
Did you cd into home/scripts before firing up sqlplus ?
-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-07-2003 03:00 AM
11-07-2003 03:00 AM
Re: problem executing sql script
Cathy,
As Graham has correctly stated sqlplus looks for sql scripts with an extension of .sql
It automatically assumes that there is an extension of .sql on the file, if another extension has not been stated.
If your script is in /home/scripts
and is called whoami
First rename the script whoami to whoami.sql
Then, from a SQL> prompt type either
@/home/scripts/whoami
or
@/home/scripts/whoami.sql
They equate to the same thing.
As Graham has correctly stated sqlplus looks for sql scripts with an extension of .sql
It automatically assumes that there is an extension of .sql on the file, if another extension has not been stated.
If your script is in /home/scripts
and is called whoami
First rename the script whoami to whoami.sql
Then, from a SQL> prompt type either
@/home/scripts/whoami
or
@/home/scripts/whoami.sql
They equate to the same thing.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
End of content
United States
Hewlett Packard Enterprise International
Communities
- Communities
- HPE Blogs and Forum
© Copyright 2021 Hewlett Packard Enterprise Development LP