I am working on a project with lots of data insert,update and select from or to Oracle 8i. I created a bunch of stored procs in Oracle package to handle these tasks and in
Java code i use Callable statement to call these stored procs, of couse i have to set up all the parameters first. but my boss suggests to use strait PL/SQL in java code, pass to Oracle as a
string through
JDBC, so will gain the performance by without set up all the parameters. I'm not very sure about his suggestion, does that mean passing PL/SQL as a string to database is better than call stored procs?
Thanks a lot