Very Computer

I am trying to run this script that I found, and am getting an error.  I
normally use bash.  I have tried 2 different ways to run it, and I get
errors on both.  I would appreciate any advice:

--Using bash

: Command not found.

--Using C Shell

/home/oracle> host.csh
'nknown option: `-
Usage: csh [ -bcdefilmnqstvVxX ] [ argument ... ].

---------------------begin file

#!/bin/csh -f

sqlplus buck/password <<"EOF" | grep '^#' | sed 's/^.//' > tmp.csh

set serveroutput on

declare
        status  number;
        command varchar2(255);
begin
        status := dbms_pipe.receive_message( 'HOST_PIPE' );
        if ( status <> 0 ) then
                dbms_output.put_line( '#exit' );
        else
                dbms_pipe.unpack_message( command );
                dbms_output.put_line( '##!/bin/csh -f' );
                dbms_output.put_line( '#' || command );
                dbms_output.put_line( '#exec host.csh' );
        end if;
end;
/
spool off
"EOF"

chmod +x tmp.csh
exec tmp.csh

---------------------end file

With tcsh,  it seems to  work (replacing sqlplus buck/password  by cat
since I don't have a running oracle).

Since it objects on ':', I'd say that your csh can't parse <<"EOF"|grep ...

Either use bash, or try to do it with a temporary file:
#!/bin/csh -f
sqlplus buck/password >tmp1 <<"EOF"
...
EOF
grep '^#' tmp1| sed 's/^.//' > tmp.csh

Since you don't use anything specific to csh, you can just replace the
first line by: #!/bin/sh

Quote:> --Using C Shell

          ^
This is the error.

--
__Pascal_Bourguignon__                   http://www.informatimago.com/
----------------------------------------------------------------------
There is a fault in reality. Do not adjust your minds. -- Salman Rushdie

I'm willing to bet that the path to csh isn't /bin/csh, use the
following command to find it's path:

type csh

On all my systems csh is in /bin, oh check to see if it's a link (
ls -l <PATH_To_csh>) and see if the link is good. I hope that helps.

--

http://mywebpages.comcast.net/ncherry/                  (Text only)
http://linuxha.sourceforge.net/                         (SourceForge)
http://hcs.sourceforge.net/                             (HCS II)

On Sat, 25 Jan 2003 15:26:01 GMT, Buck Turgidson

This error seems to indicate that the script contains control characters.
You probably copied it from a Windoze machine without using "dos2unix"
or a similar filter.

All excellent responses.  Thanks.  This is what the problem was.  I use
samba and Visual Slick Edit.  I saved it as type UNIX rather than DOS.

Or instead of going to all the trouble of samba and Visual Slick Edit,
you might want to try NEdit, which will also read/write/convert unix and
dos formats, and is a superb editor too.
http://www.nedit.org/

--