<div>
looked good, &nbsp;only thing would be to add explicit conversions so your parameters will be converted to dates and have the date math work correctly<br />
<br />
exec mytestpack('$1',last_day(t<wbr />o_date('$3<wbr />','DD-MON-<wbr />YYYY'))+1,<wbr />add_months<wbr />(to_date('<wbr />$2','DD-MO<wbr />N-YYYY'), 1) - 1)<br />

</div>


<div>
did not work - I got no results for the above change..<br />
do I need to declare the $3 and $2 to be a date parameter..? eventhough I am passing oracle default date format like '31-DEC-2008' as value?
</div>


<div>
You're using the Unix shell symbol for variable substitution (&quot;$&quot;) instead of the SQL*Plus symbol (&quot;&amp;&quot;). &nbsp;Try using ampersands rather than dollar signs.
</div>


<div>
I did create unix shell file to call sqlplus - sorry for not being clear..<br />
cat test.ksh<br />
sqlplus -s $LOGIN &lt;&lt;EOF<br />
exec mytestpack('$1',last_day(t<wbr />o_date('$3<wbr />','DD-MON-<wbr />YYYY'))+1,<wbr />add_months<wbr />(to_date('<wbr />$2','DD-MO<wbr />N-YYYY'), 1) - 1)<br />
EOF<br />
<br />
the above is the contents of the file I am testing..
</div>


<div>
I was assuming your $1, $2 and $3 were just place holders.<br />
<br />
Is that literally what you have in your script?<br />
<br />
if so, please post your entire script so we can see how you're invoking this
</div>


<div>
oops, you just did! &nbsp;thanks
</div>


<div>
and when I call test.ksh I do<br />
test.ksh unique_id1 '31-DEC-2008' '31-DEC-2008'
</div>


<div>
<div class="content wysiwyg-content">
I need to call oracle package from sqlplus and have to change the parameters that it gets to as follows<br />
<br />
exec mytestpack('$1',last_day('<wbr />$3')+1,add<wbr />_months('$<wbr />2', 1) - 1)<br />
$1 - is unique id value<br />
$2 - date parameter usually 31-DEC-2008 - <br />
$3- date parameter usually 31-DEC-2008<br />
how do I call the package with adding funcitons in the parameter like last_day and add_months?<br />
I need a quick turnaround on this - any help will be appreciated - this is oracle 10.2.0<br />
Thanks!!
</div>
</div>


I need to call oracle package from sqlplus and have to change the parameters that it gets to as follows

exec mytestpack('$1',last_day('$3')+1,add_months('$2', 1) - 1)
$1 - is unique id value
$2 - date parameter usually 31-DEC-2008 - 
$3- date parameter usually 31-DEC-2008
how do I call the package with adding funcitons in the parameter like last_day and add_months?
I need a quick turnaround on this - any help will be appreciated - this is oracle 10.2.0
Thanks!!

calling package from sqlplus using parameters

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.