Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oci_invalid_handle error in toad

Status
Not open for further replies.

Advocate

IS-IT--Management
Oct 18, 2000
135
GB
greetings,

select * from all_scheduler_jobs

is consistently giving me an oci_invalid_handle error in toad 8.0 (reverted from 8.5 because it was giving me errors with ext tables ... havent tried 8.6 yet)

if i open another toad session it "sometimes" will run the query ok

only happens for scheduler queries ...

tried increasing oracle/geeral/oci_array_buffer_size 25 > 500 etc but no joy ...

any ideas please ? nothing in help or google etc




regards, david - no such thing as problems - only solutions.
 
sitrep ...

this dbms_scheduler queries error seems to have disappeared with toad latest 8.6 release

8.6 also seems to have stopped my pc from freezing/bomb out when trying to view ext table data and ext file is not available

good to go ...

regards, david - no such thing as problems - only solutions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top