Discussions

General J2EE: Java- Stored Procedure Error

  1. Java- Stored Procedure Error (2 messages)

    Hi,
    My java programme from a development server is calling a stored procedure which is there in another database server.
    The programme is getting hanged.
    But I try in Database server by useing PL/SQL Developer IDE ant two more. There it is working properly. I could not figure out where is the error.
    Note:
    I have check all parameters that are passed to stored procedure, they are correct.
    Please suugest me on the same.
    Thanks in Advance.

    Vijay
  2. Are you getting Any execption? Can you connect to database using some other client tool?
  3. Thanks for reply.
    Details on the error
    I connected to the DB server through PL/SQL Developer IDE.
    The stored procedure is running and yields the result.
    But through Java database object is created and hanging at
    obj_db.execute(proc_name(parameters along with return parameters));
    and the site is going for Server time out
    Below is the message
    "
    While trying to retrieve the URL: [no URL]

    The following error was encountered:

    Read Timeout
    The system returned:

        [No Error]
    A Timeout occurred while waiting to read data from the network. The network or server may be down or congested. Please retry your request.

    Your cache administrator is webmaster. "