Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    3
    Rep Power
    0

    Default 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.

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,957
    Rep Power
    19

    Default 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.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. why should we invoke empty construtor
    By prabhajan in forum New To Java
    Replies: 5
    Last Post: 01-31-2011, 05:50 AM
  2. reflection invoke method
    By pprl in forum New To Java
    Replies: 12
    Last Post: 11-16-2010, 05:43 PM
  3. How to invoke thread2 after the thread1
    By erosszz_jp@yahoo.co.jp in forum Threads and Synchronization
    Replies: 4
    Last Post: 09-02-2010, 04:31 PM
  4. Invoke Applet
    By chankokchern in forum Java Applets
    Replies: 1
    Last Post: 07-29-2008, 04:35 PM
  5. Re address to jsp to that I invoke it
    By Marcus in forum JavaServer Pages (JSP) and JSTL
    Replies: 1
    Last Post: 06-09-2007, 04:31 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •