how to invoke sqlplus from jsp
String sql1="execute DBMS_SYSTEM.set_sql_trace_in_session("+sid_number+ ", "+sl_no+",true)";
Trying to execute this statement using the preparedstatement and callable statement from jsp, but its showing error:
500 Internal Server Error
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.
i'm new to jsp, pls clarify with an example code.
Re: how to invoke sqlplus from jsp
Find the full exception from your server logs.
That will tell you the full problem that Oracle has thrown.
I will say, though, that you cannot run SQLPlus commands in Oracle.