Re: sql embedded into unix shell script

2008-10-15 Thread drain
was an indentation problem in the main script...the code is correct and works thanks On 14 Ott, 16:15, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > On Oct 14, 9:40 am, drain <[EMAIL PROTECTED]> wrote: > > > > > was wrong.. that modify doesn't fix the problem... > > > On 14 Ott, 14:30, drain <

Re: sql embedded into unix shell script

2008-10-14 Thread fitzjarr...@cox.net
On Oct 14, 9:40 am, drain <[EMAIL PROTECTED]> wrote: > was wrong.. that modify doesn't fix the problem... > > On 14 Ott, 14:30, drain <[EMAIL PROTECTED]> wrote: > > > > > found the curse error... > > > last EOF must be write at the end of the line: > > > SCHEDULE=`$ORACLE_HOME/bin/sqlplus -s $US

Re: sql embedded into unix shell script

2008-10-14 Thread drain
was wrong.. that modify doesn't fix the problem... On 14 Ott, 14:30, drain <[EMAIL PROTECTED]> wrote: > found the curse error... > > last EOF must be write at the end of the line: > > SCHEDULE=`$ORACLE_HOME/bin/sqlplus -s $USR/[EMAIL PROTECTED] < set pagesize 0 feedback off verify off heading off

Re: sql embedded into unix shell script

2008-10-14 Thread drain
found the curse error... last EOF must be write at the end of the line: SCHEDULE=`$ORACLE_HOME/bin/sqlplus -s $USR/[EMAIL PROTECTED] < wrote: > nothing to do, i already set all variables in > > # var initialization > > but the following code returns: > SP2-0042: unknown command "EOF" - rest of

Re: sql embedded into unix shell script

2008-10-14 Thread drain
nothing to do, i already set all variables in # var initialization but the following code returns: SP2-0042: unknown command "EOF" - rest of line ignored. SCHEDULE=`$ORACLE_HOME/bin/sqlplus -s $USR/[EMAIL PROTECTED] < wrote: > On Oct 14, 6:04 am, drain <[EMAIL PROTECTED]> wrote: > > > > > Hell

Re: sql embedded into unix shell script

2008-10-14 Thread fitzjarr...@cox.net
On Oct 14, 6:04 am, drain <[EMAIL PROTECTED]> wrote: > Hello, if i run this code in unix shell interactive mode: > > # var initialization > > SCHEDULE=`$ORACLE_HOME/bin/sqlplus $USR/[EMAIL PROTECTED] < set pagesize 0 feedback off verify off heading off echo off > SELECT SCHEDULE FROM $TAB WHERE

sql embedded into unix shell script

2008-10-14 Thread drain
Hello, if i run this code in unix shell interactive mode: # var initialization SCHEDULE=`$ORACLE_HOME/bin/sqlplus $USR/[EMAIL PROTECTED] < ::= [/][@] how i can fix the script? Thanks, Drain --~--~-~--~~~---~--~~ You received this message because you are subscri