<div>
<div class="content wysiwyg-content">
I have a problem when I have a unix script calling oracle package and I want to write the result to a log<br />
assume package first has 2 param's<br />
so I have a k shell to call <br />
sqlplus -s $LOGIN &lt;&lt;&nbsp;EOF<br />
execute first(first param,second param) &gt;&nbsp;$MYDIR/log/first.log<br />
EOF<br />
I get an error that &gt;&nbsp;is not accepted inside the execution - how will i then record the message in the log?
</div>
</div>


I have a problem when I have a unix script calling oracle package and I want to write the result to a log
assume package first has 2 param's
so I have a k shell to call 
sqlplus -s $LOGIN << EOF
execute first(first param,second param) > $MYDIR/log/first.log
EOF
I get an error that > is not accepted inside the execution - how will i then record the message in the log?

calling package from unix writing  log files.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.