SOLVED-ORA-01013: user requested cancel

Discussion in 'ASP General' started by shall@uaex.edu, Jul 26, 2007.

  1. Guest

    I was getting this error message using an ASP
    to run a stored procedure in ORACLE.
    ORA-01013: user requested cancel of current operation

    My stored procedure was taking a long time to process.
    Which is what I expected.

    In the ASP page:

    set cmd = server.CreateObject ("ADODB.Command")
    with cmd
    set .ActiveConnection = cnn3
    ..CommandTimeout=300 '' <= I added This
    ..CommandText = mySQL
    ..CommandType = 4 'adCmdStoredProc

    I set it to 300 now the web works.
    I hope this helps someone else.
    Steve
    , Jul 26, 2007
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. biteside
    Replies:
    0
    Views:
    4,345
    biteside
    Oct 13, 2003
  2. ʹÃûÑï
    Replies:
    0
    Views:
    4,039
    ʹÃûÑï
    Jun 18, 2004
  3. Bruno Abud via .NET 247

    ORA-12564 with Oracle Client

    Bruno Abud via .NET 247, Aug 11, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    3,127
    Bruno Abud via .NET 247
    Aug 11, 2004
  4. Michael Bacarella
    Replies:
    26
    Views:
    1,315
    harri
    Nov 20, 2007
  5. Derk
    Replies:
    1
    Views:
    190
    Roland Hall
    Apr 7, 2004
Loading...

Share This Page