Code Assistant causing errors

[mcooper]

When I have Code Assistant turned on, I get an "Oracle not connected" error whenever it tries to retrieve data dictionary information. Specifically whenever I type a comma in an insert statement or a period in a select statement.

I've been using PL/SQL Developer for over a year now and this issue has just started within the past week.

Currently, my workaround is to turn off code assistant. Has anyone run into this issue? Also, I have two Oracle servers that I work with. This happens when connected to one server (enterprise edition), but not the other (standard edition).

Thanks,

 

[Marco Kalter]

Maybe this is an environment problem. Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[mcooper]

Marco,
Thanks for replying. Sorry it's taken me so long to get back to you. I've been having trouble with my PL/SQL developer about box. Here is the information you requested.

--- Info ---

PL/SQL Developer
Version 6.0.4.906 (MBCS)
01.15859 - 7 user license
Windows XP version 5.5 (build 3790)

Physical memory : 2,097,152 kB (2,097,152 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (2,035,900 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
DEV9
DEV902
DEV902_DSIAPP02

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.1.0
Character size: 1 byte(s)

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = C:\oracle\ora92
ORACLE_HOME_NAME = OraHome92
API = C:\oracle\ora92\dbs
ORACLE_GROUP_NAME = Oracle - OraHome92
NLS_LANG = NA
OLEDB = C:\oracle\ora92\oledb\mesg
VOBHOME2.0 = C:\oracle\ora92
OO4O = C:\oracle\ora92\oo4o\mesg

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OraHome92
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome92
PATH = C:\oracle\ora92
NLS_LANG = NA

SOFTWARE\ORACLE\AUTOTUNE9.2.0
help_path = ${vobhome2.0}bin/
debug_flags =
startlog = ${home}autotune/%1.log
trace_report = 0
trace_data = 0
collect_int_in_min = 15
analyze_int_in_hrs = 24
max_errors_allowed = 5
wip_batch = 0
wip_window = 0
wip_logfile = 0
wip_logtable = 0

SOFTWARE\ORACLE\EXPERT9.2.0
home = ${vobhome2.0}sysman/expert
help_path = ${vobhome2.0}bin/
xpcoin = ${vobhome2.0}bin/xpcoin
default_rule_file = xpo000
debug_flags =
sample = ${home}sample/
sample_xdl = ${sample}xppso.xdl
startlog = ${vobhome2.0}sysman/temp/xpexpert.log
trace_report = 0
trace_data = 0
max_orphan_txn_reqs = 100
max_cache_txn_reqs = 50
extract_explain_plan = 0
create_tmp_plan_table = 0
tmp_plan_table = xp_tmp_plan
wip_batch = 0
wip_window = 1
wip_logfile = 0
wip_logtable = 0
quicktour_start = ${vobhome2.0}classes/oracle/sysman/qtour/tune/us/tune.htm
report_viewer = write
startup_wizard = 1
collect_trace_stats = 1
standalone_mode = 0

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome92
ORACLE_HOME_NAME = OraHome92
ORACLE_HOME = C:\oracle\ora92
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = C:\oracle\ora92\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
ORACLE_HOME_KEY = Software\ORACLE\HOME0
SQLPATH = C:\oracle\ora92\dbs
MSHELP_TOOLS = C:\oracle\ora92\MSHELP

SOFTWARE\ORACLE\iSQLPlus
ServerCount = ServerURIColWidth =

 

[Marco Kalter]

This looks okay to me. To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.