Hello, if i run this code in unix shell interactive mode:
# var initialization
SCHEDULE=`$ORACLE_HOME/bin/sqlplus $USR/[EMAIL PROTECTED] <<EOF
set pagesize 0 feedback off verify off heading off echo off
SELECT SCHEDULE FROM $TAB WHERE NOME_REPORT='$NOME_REPORT';
EOF`
then works fine, instead when i try same code inside shell script
(.sh) i obtain these error:
SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|
SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_string>]
how i can fix the script?
Thanks,
Drain
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
