Sponsored Content
Top Forums Shell Programming and Scripting Here document and shell scripting Post 302398356 by kshji on Wednesday 24th of February 2010 10:33:10 AM
Old 02-24-2010
EOF must be in column 1.
I have not used sqlplus, but maybe sql file is argument, not stdin ?
Code:
for sid in $sids
do
    ORACLE_SID=$sid
    ORACLE_HOME=$(grep "$sid" $ORATAB_LOC |cut -f2 -d':')
    echo $ORACLE_HOME $ORACLE_SID
    $ORACLE_HOME/bin/sqlplus -s /nolog <<EOF
    @$HOME/sql/checkdb-status.sql
EOF
done


Code:
sqlplus   @some.sql
#or
sqlplus <<EOF
$( cat some.sql )
EOF
#or
sqlplus <<EOF
somesql;
cmd2;
quit;
EOF

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

2. Programming

UNIX Shell Script to Create a Document of a PLSQL code.

Hi All, I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (1 Reply)
Discussion started by: gauravsachan
1 Replies

3. Shell Programming and Scripting

Shell Scripted Document Management System

Over the past 4 -5 years, I have cobbled together a rudimentary 'Document Management System' for a school district I support using Linux Bash Shell scripts.. The purpose of the scripting was to supplement features of a Job Applicant Center that had very simplistic methods of handle file... (1 Reply)
Discussion started by: rmuledeer
1 Replies

4. Shell Programming and Scripting

Call Shell scripting from Perl Scripting.

Hi How to call a shell scripting through a Perl scripting? Actually I need some value from Shell scripting and passes in the Perl scripting. So how can i do this? (2 Replies)
Discussion started by: anupdas
2 Replies

5. UNIX for Dummies Questions & Answers

Need Shell Script for document searching

I need a script that reads only printable characters (no duplicates) from all files in a directory and output them in a text file. (2 Replies)
Discussion started by: l20N1N
2 Replies

6. What is on Your Mind?

Shell scripting vs Perl scripting

Hi all, I would like to start developping some good scripting skills. Do you think it would be best to start with shell scripting or Perl? I already got a fundation, really basics, in perl. but I am wondering what would be best to be good at first. Can you please help me determine which one to... (14 Replies)
Discussion started by: Pouchie1
14 Replies

7. Shell Programming and Scripting

Oracle Shell script | here document `EOF' unclosed

Hi folks I m creating script which is give me below error. $ ./function.ksh ./function.ksh: here document `EOF' unclosed Inside the script is #!/bin/ksh export ORACLE_SID=OECDV1 export ORACLE_HOME=/u01/app/oracle/product/10.2.0 export PATH=$ORACLE_HOME/bin:$PATH echo "sql is... (3 Replies)
Discussion started by: tapia
3 Replies

8. Web Development

Perl scripting or shell scripting?

i am going to study any one of the scripting languages mentioned above(shell 0r perl scripting) . Which is having more scope for a fresher? (1 Reply)
Discussion started by: Anna Hussie
1 Replies

9. Shell Programming and Scripting

HERE Document in Shell Script

Hi, I have a shell script to install one of our products. It comprises of commands that are specific to the product installation. These commands require user inputs at different stages. To avoid manual feeding of inputs every time, I tried using HERE document. it is like- #! /usr/bin ... (1 Reply)
Discussion started by: nishant.kansal@
1 Replies

10. UNIX for Beginners Questions & Answers

UNIX Shell Script to Remove MongoDB Document-Based on Many inputs

Here I am in a position to write a Unix Shell script(.sh) to remove MongoDB collection documents. I know how to remove based on a condition like below and it works for me. eval 'db.Collection.remove({TimeStamp:{$lte: "'$var'"}}) But I need to change the remove statement based on a new parameter... (1 Reply)
Discussion started by: senthilmadhanT
1 Replies
MBR_UID_TO_UUID(3)					   BSD Library Functions Manual 					MBR_UID_TO_UUID(3)

NAME
mbr_uid_to_uuid, mbr_gid_to_uuid, mbr_uuid_to_id, mbr_sid_to_uuid, mbr_uuid_to_sid -- user and group identifier translation functions SYNOPSIS
#include <membership.h> int mbr_uid_to_uuid(uid_t id, uuid_t uu); int mbr_gid_to_uuid(gid_t id, uuid_t uu); int mbr_uuid_to_id(const uuid_t uu, uid_t *id, int *id_type); int mbr_sid_to_uuid(const nt_sid_t *sid, uuid_t uu); int mbr_uuid_to_sid(const uuid_t uu, nt_sid_t *sid); int mbr_sid_to_string(const nt_sid_t *sid, char *string); int mbr_string_to_sid(const char *string, nt_sid_t *sid); DESCRIPTION
Users and groups can be referred to in multiple ways. In addition to the traditional uid and gid, every user or group can be referenced by a 128 bit uuid. Additionally, if the user or group is hosted on a PDC or Active Directory server, it will have a 128 bit or larger sid. These routines communicate with opendirectoryd(8). mbr_uid_to_uuid() takes a uid and looks up the associated user account. It provides the the uuid for that user as an output parameter. Note that this routine will succeed and return a fabricated uuid if the input user uid does not exist. getpwuid() should be used to test for the existence of a uid. mbr_gid_to_uuid() similarly gets the uuid associated with a group. Note that this routine will succeed and return a fabricated uuid if the input group gid does not exist. getgrgid() should be used to test for the existence of a gid. mbr_uuid_to_id() takes a uuid that refers to a user or group and fetches the corresponding uid or gid. id_type is set to ID_TYPE_UID or ID_TYPE_GID to indicate which type was found. Note that mbr_uuid_to_id() always returns an id even if the uuid is not found. This returned id is not persistent, but can be used to map back to the uuid during runtime. To determine if the uuid exists, the returned id can be used in a call to getpwuid(3) or getgrgid(3). mbr_sid_to_uuid() takes a sid and returns the associated uuid. mbr_uuid_to_sid() returns a sid for the associated uuid. Two additional utility functions are available to convert between sids and a string representation. String representations may be required, for example, when text files or XML files are used to save sid values. mbr_sid_to_string() converts a sid into a string representation. The string parameter must be a buffer of at least 194 characters. The con- verted string is terminated with a nul character. mbr_string_to_sid() converts an external string representation into a sid. RETURN VALUES
These functions return 0 on success or one of the following error codes on failure: [EIO] Communication with opendirectoryd(8) failed. [ENOENT] The mapping can not be performed. [EAUTH] Communication with opendirectoryd(8) failed due to an authentication error. [EINVAL] Invalid arguments were provided. [ENOMEM] Insufficient storage space is available. mbr_gid_to_uuid() and mbr_uid_to_uuid() return 0 (success), even if the user/group does not exist. SEE ALSO
getpwuid(3), getgrgid(3), mbr_check_membership(3), opendirectoryd(8) Mac OS X October 10, 2011 Mac OS X
All times are GMT -4. The time now is 10:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy