Avatar of ralph_rea
ralph_rea
 asked on

ORA-01013: user requested cancel of current operation

Hi,
I've an application on Oracle 10.2.0.3.0 that run a basic script but I get always this error:
ORA-01013: user requested cancel of current operation

I was thinking to solve the problem by changing the ODBC settings in ODBC sources, I'd like to uncheck the "Enable Query Timeout" option, BUT when I trying to do the following with the Oracle ODBC Driver version 10.2.0.3.0 I get the error:
"An unsupported operation was attempted"

Have someone any idea How can I fix my ORA-01013 error and ODBC error?

Thanks in advance!
Oracle DatabaseVB Script

Avatar of undefined
Last Comment
jostrander

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
k_murli_krishna

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
k_murli_krishna

See this as well:
http://www.dba-portal.eu/?q=node/31
http://Metalink.oracle.com for patches and updates.
Metalink is not free, and the newest, fancy version, called my Oracle
support, also requires Flash.
jostrander

Another way to disable query timeout is through the registry.

HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\<your entry>
or for user-based ODBC entry:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<your entry>

Look for the QueryTimeout string value... Change from T to F

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck