<div>
Its just an oracle database, with access through putty.<br />
I think im actually talking to your self about the same subjuct under a differnt question header.<br />
Answer under which ever question header you wish, sorry for that, i seem to have crossed streams of thought.
</div>


<div>
This question is continues in the other question string, but heres the points, you have been very helpful so far!
</div>


<div>
putty is the program you use to access the computer. &nbsp;It's a terminal emulation program, not an operating system. &nbsp;When you connect thru putty and see a command prompt you are in the operating system's command shell. &nbsp;That's what we need to know because the command you can enter there a re different depending on whether you are in c-shell, CS, Korn, or some other shell. &nbsp;You need to ask your system administrator what version of unix/linux you are using and which shell.<br />
<br />
The following will work, if the subprocess that TSW creates (no, I don't know what TSW is) runs the .profile so that it knows what sqlplus is:<br />
<br />
sqlplus /@ @UnAllocableStock1.sql<br />
<br />
This assumes that you use the &quot;WHENEVER&quot; I gave you in the other thread.<br />
<br />
Good luck!<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I need to create a shell script that runs a plsql query called UnAllocableStock1.<br />
The shell will execute the plsql and return a value of 0 or &gt;&nbsp;to TSW to indicate success or failure.<br />
Thanks 
</div>
</div>


Hi,
I need to create a shell script that runs a plsql query called UnAllocableStock1.
The shell will execute the plsql and return a value of 0 or > to TSW to indicate success or failure.
Thanks 

I need to create a shell script that runs a plsql query

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.