Avatar of mahjag

asked on 

calling package from sqlplus using parameters

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
Oracle Database

Avatar of undefined
Last Comment
Sean Stuber

8/22/2022 - Mon