When I run a pass-thru query, the data is returned, however if a make-table query is run on the pass-thru, the ORA error is returned. The pass-thru query's time out is set to 0. I don't think this is an oracle error because the pass-thru query works. Any ideas?
ORA-01013 error. (1 Viewer)
- Thread starter elliotgr
- Start date
- Local time
- Today, 05:13
- Joined
- Jan 23, 2006
- Messages
- 15,383
Yes it's an Oracle error - that's why it has an ORA prefix.
see http://www.dba-oracle.com/t_ora_01013_user_requested_cancel_of_current_operation.htm
see http://www.dba-oracle.com/t_ora_01013_user_requested_cancel_of_current_operation.htm
Thanks, it was confusing as the pass-thru query worked, but not the make-table query. After further investigation it appears the schema rights are not explicitly defined in the oracle database to the user running the select statement.. Must just get the Oracle DBA to resolve.
