- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Calling sqlplus scripts from unix
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- 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
- Report Inappropriate Content
тАО02-02-2001 08:46 AM
тАО02-02-2001 08:46 AM
Calling sqlplus scripts from unix
unix script
sqlplus_script_1 v1 v2 v3 v4 v5 v6
sqlplus_script_1_1 &1 &2
sqlplus_script_1_2 &3 &4
sqlplus_script_1_3 &5 &6
(ALL THE ABOVE SCRIPTS WORK FINE)
sqlplus_script_1_4 &1 &2
(Now sqlplus_script_1_4 uses the value for v5 and v6 instead of using v1 v2.)
Is this how it is supposed to work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2001 10:12 AM
тАО02-02-2001 10:12 AM
Re: Calling sqlplus scripts from unix
I think the problem is, by calling those scripts, you reassign values to &1 &2 all the time. May be you schould print &1 &2 between those calls. I think it will show them destroyed after the second call.
You schould save the values after the first call:
DEFINE P1 = &1
DEFINE P2 = &2
...
and call your scripts with those variables.
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2001 10:29 AM
тАО02-02-2001 10:29 AM
Re: Calling sqlplus scripts from unix
sqlplus_script_1_4 ${P1} ${P2}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2001 02:28 PM
тАО02-02-2001 02:28 PM
Re: Calling sqlplus scripts from unix
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2001 11:41 PM
тАО02-05-2001 11:41 PM
Re: Calling sqlplus scripts from unix
Just to keep in mind how this forum works.
Best Regards
Volker