Requests ...

[CTucker]

1) It would be nice to have an option on the right-click menu in the Program Window (of a package specification or body) to open up the corresponding package body for the current package spec and vice versa (this will open a new Program Window tab if the spec/body is not already open or just switch the focus between tabs if the source is already open). This is particularly helpful when using hyperlink navigation. When using hyperlink navigation for a procedure or function that is implemented in another package you are taken to the package specification, however if you want to drill deeper by navigating to the package body you cannot open it directly from the specification.

2) It would be nice to have the SQL Results Window automatically fetch the next set of records when the user scrolls beyond the last retrieved record (or resizes the window larger so the more records can be displayed). Maybe have an option so that the default behaviour can be defined as being "Fetch Next" or "Fetch All".

3) It would be nice to have a flavor of the find matching pair function (or the find matching pair function itself) that finds the next "elsif" or "else" in an "if" statement. Find matching pair currently jumps from "if" to "end if" and it would be extremely useful to jump through all related conditions, i.e. "if" ... "elsif" ... "else" ... "end if".

4) Problem: None of the Beautifier options seem to apply to the FETCH statement. My preference is to have all list items appear on separate lines, however for FETCH statements the list items after the INTO clause are always placed on a single line.

Request: Can an option be added to treat the AND/OR in where clauses as keywords - to me it does not make sense to have rules for formatting DML when you have no control over how the where clause is to be treated. Also, it would be nice to allow the Beautifier ignore DML, Control Structures, Parameter Declarations, etc. so that you enforce standards for DML and Parameter Declarations but let the rest go.

[This message has been edited by CTucker (edited 24 April 2003).]

 

[CTucker]

One additional problem... when I have the Editor option "allow cursor at end of line" checked and I select text in the SQL or Program window such that the cursor is beyond the end of the last line selected and I press the nothing happens. However when I press the text is deleted as expected. My expectation is the the would work as the does in this situation.

 

[Marco Kalter]

We'll look into the problems, and I have added the requests to the list of the enhancement requests.

------------------
Marco Kalter
Allround Automations

 

[Rob Wills]

Originally posted by CTucker:
One additional problem... when I have the Editor option "allow cursor at end of line" checked and I select text in the SQL or Program window such that the cursor is beyond the end of the last line selected and I press the nothing happens. However when I press the text is deleted as expected. My expectation is the the would work as the does in this situation.

Has this been fixed? As of 1/25/2005 I have the latest version of developer and I still experience the backspace issue mentioned in this posting. Any help would be appreciated. Thanks.

 

[Marco Kalter]

This should be fixed. Do you have any Plug-Ins installed? 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?

 

[Rob Wills]

--- Info ---

PL/SQL Developer
Version 6.0.4.906 (MBCS)
01.16084 - 10 user license
Windows 2000 version 5.0 (build 2195) Service Pack 4

Physical memory : 522,228 kB (252,448 available)
Paging file : 1,277,064 kB (993,016 available)
Virtual memory : 2,097,024 kB (2,008,296 available)

Parameters
D:\Program Files\PLSQL Developer\plsqldev.exe

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

Plug-Ins

Aliases
abc2.REPUBLIC.COM
acp.republic.com
ACPX.REPUBLIC.COM
ADMN.REPUBLIC.COM
DBA.REPUBLIC.COM
...

Homes
Dev2k (D:\oracle\Dev2k)
OraHome81 (D:\oracle\ora81)
WrkFlow (D:\Oracle)

DLLs
D:\Oracle\bin\oci.dll

TNS File
P:\SQLNET\ICEMAN\tnsnames.ora

Using
Home: WrkFlow
DLL: D:\Oracle\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.5.0
Character size: 1 byte(s)

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = D:\oracle\ora81
ORACLE_HOME_NAME = OraHome81
API = D:\oracle\ora81\dbs
ORACLE_GROUP_NAME = Oracle - OraHome81
NLS_LANG = NA
OLEDB = D:\oracle\ora81\oledb\mesg
OO4O = D:\oracle\ora81\oo4o\mesg

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 3
DEFAULT_HOME = OraHome81
LAST_HOME = 2
TNS_ADMIN = P:\SQLNET\ICEMAN

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome81
PATH = D:\oracle\ora81
NLS_LANG = NA

SOFTWARE\ORACLE\ALL_HOMES\ID1
NAME = Dev2k
PATH = D:\oracle\Dev2k
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

SOFTWARE\ORACLE\ALL_HOMES\ID2
NAME = WrkFlow
PATH = D:\Oracle
NLS_LANG = NA

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome81
ORACLE_HOME_NAME = OraHome81
ORACLE_HOME = D:\oracle\ora81
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_HOME_KEY = Software\ORACLE\HOME0
SQLPATH = D:\oracle\ora81\dbs
MSHELP_TOOLS = D:\oracle\ora81\MSHELP
TNS_ADMIN = P:\SQLNET\ICEMAN

SOFTWARE\ORACLE\HOME1
ID = 1
ORACLE_HOME = D:\oracle\Dev2k
ORACLE_HOME_NAME = Dev2k
ORACLE_HOME_SERVICE = Dev2k
SHARED_ORACLE_HOME = D:\oracle\Dev2k
API = D:\oracle\Dev2k\DBS
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
COMPANY_NAME = Republic Windows & Doors, INC.
ORACLE_GROUP_NAME = Oracle for Windows NT - Dev2k
D2K60_COMPONENTS = Oracle Forms & Reports 6i Comps - Dev2k
D2K60_ADMINISTRATION = Oracle Forms & Reports 6i Admin - Dev2k
D2KOR60_ADMINISTRATION = Oracle Reports 6i Admin - Dev2k
D2KIF60_ADMINISTRATION = Oracle Forms 6i Admin - Dev2k
D2K60_DEMOS = Oracle Forms & Reports 6i Demos - Dev2k
D2K60_DOCS = Oracle Forms & Reports 6i Doc - Dev2k
D2K60_GROUP = Oracle Forms & Reports 6i - Dev2k
D2KOR60_GROUP = Oracle Reports 6i - Dev2k
D2KIF60_GROUP = Oracle Forms 6i - Dev2k
D2K60_DRIVERS = Oracle Forms & Reports 6i Direct Drivers - Dev2k
OPEN2K60_DOCS = Oracle Forms & Reports 6i Doc - Dev2k
ORACLE_JDK = D:\oracle\Dev2k\JDK\
OI_NLS32 = D:\oracle\Dev2k\orainst\NLB
RDBMS80 = D:\oracle\Dev2k\RDBMS80
PLSQL80 = D:\oracle\Dev2k\PLSQL80
CORE40 = D:\oracle\Dev2k\CORE40
NLSRTL33 = D:\oracle\Dev2k\NLSRTL33
ORA_NLS33 = D:\oracle\Dev2k\NLSRTL33\DATA
PRO80 = D:\oracle\Dev2k\PRO80
OTRACE80 = D:\oracle\Dev2k\OTRACE80
NET80 = D:\oracle\Dev2k\NET80
SQLPATH = D:\oracle\Dev2k\dbs;D:\oracle\Dev2k\bin;D:\oracle\Dev2k\report60\server\security
PLUS80 = D:\oracle\Dev2k\PLUS80
EXECUTE_SQL = PLUS80
PLUS_DFLT = PLUS80
UI60 = D:\oracle\Dev2k\TOOLS\COMMON60
MM60 = D:\oracle\Dev2k\TOOLS\COMMON60
TK60 = D:\oracle\Dev2k\TOOLS\COMMON60
FORMS60 = D:\oracle\Dev2k\FORMS60
VGS60 = D:\oracle\Dev2k\TOOLS\COMMON60
DE60 = D:\oracle\Dev2k\TOOLS\COMMON60
CA_GPREFS = D:\oracle\Dev2k
CA_UPREFS = D:\oracle\Dev2k
QT_PLAYER = OMO
DEV2000_SOURCECONTROL = PVCS
DEV2000_PROJECT = None
DEV2000_SCVIEWER = Notepad.exe
DEV2000_SCCONVERT = FALSE
DOC60 = D:\oracle\Dev2k\TOOLS\DOC60
OIN60 = D:\oracle\Dev2k\OIN60
ORAINFONAV_DOCPATH = D:\oracle\Dev2k\OIN
ORAINFONAV_CDPATH = L:\Information Services\IS Support\Oracle Apps DBA\Sofware\FormsReports\INSTALL
BROWSER60 = D:\oracle\Dev2k\BROWSE60
GRAPHICS60 = D:\oracle\Dev2k\TOOLS\DBTAB60\GRAPH60
OCL60 = D:\oracle\Dev2k\TOOLS\DBTAB60\GRAPH60
GRAPHOGD60 = D:\oracle\Dev2k\TOOLS\DBTAB60\GRAPH60\GWIZ_OGD
GRAPHBMP60 = D:\oracle\Dev2k\TOOLS\DBTAB60\GRAPH60\GWIZ_BMP
GWIZARD60 = D:\oracle\Dev2k\TOOLS\DBTAB60\GRAPH60
OIN = D:\oracle\Dev2k\OIN
doc60_nls = D:\oracle\Dev2k\TOOLS\DOC60\US
OTM60 = D:\oracle\Dev2k\OTM60
PJ60 = D:\oracle\Dev2k\PJ60
OPEN60 = D:\oracle\Dev2k\TOOLS\OPEN60
D2TX60 = D:\oracle\Dev2k\TOOLS\OPEN60\TUXEDO
OPEN60_PLSQL = D:\oracle\Dev2k\TOOLS\OPEN60\PLSQLLIB
FORMS60_PATH = o:\xn8\system\dvlplibs
TNS_ADMIN = p:\SQLNET\ICEMAN
REPORTS60_DB_AUTH = dbauth.htm
REPORTS60_SYS_AUTH = sysauth.htm
RW60 = D:\oracle\Dev2k\REPORT60
REPORTS_RUNTIME = rwrun60.exe
REPORTS_BUILDER = rwbld60.exe
REPORTS60_SPLASH = TRUE
REPORTS60_EXPRESS_UI = D:\oracle\Dev2k\bin
GSINSTALLDIR = D:\oracle\Dev2k\olap\ece620
GSCONNECTDIR = D:\oracle\Dev2k\olap\ecf620
REPORTS60_PATH = D:\oracle\Dev2k\REPORT60\ADMIN\TEMPLATE\US;D:\oracle\Dev2k\REPORT60
REPORTS60_TMP = D:\oracle\Dev2k\REPORT60\TMP
REPORTS60_JNI_LIB = D:\oracle\Dev2k\jdk\bin\javai.dll
REPORTS60_CLASSPATH = D:\oracle\Dev2k\jdk\lib\classes.zip;D:\oracle\Dev2k\REPORT60\java\jars\myreports60.jar;D:\oracle\Dev2k\REPORT60\java\jars\xmlparser.jar
REPORTS60_DEV2K = FALSE

SOFTWARE\ORACLE\HOME2
ID = 2
ORACLE_GROUP_NAME = Oracle - WrkFlow
ORACLE_HOME_NAME = WrkFlow
ORACLE_HOME = D:\Oracle
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
ORACLE_HOME_KEY = Software\ORACLE\HOME2
TNS_ADMIN = P:\SQLNET\ICEMAN

SOFTWARE\ORACLE\JInitiator
Java Runtime = Default
JIT Enabled = 1
JIT path = symcjit
Java Runtime Parameters = -mx64m -Dcache.size=50000000
Show Console = 0
Debug Mode = 0

SOFTWARE\ORACLE\JInitiator\1.1

SOFTWARE\ORACLE\JInitiator\1.1.8

SOFTWARE\ORACLE\JInitiator\1.1.8.16
Home = d:\PROGRA~1\Oracle\JINITI~1.16

SOFTWARE\ORACLE\JInitiator\Default
Home = d:\PROGRA~1\Oracle\JINITI~1.16

SOFTWARE\ORACLE\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRSet = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0

SOFTWARE\ORACLE\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = D:\oracle\ora81\MSHELP\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = D:\oracle\ora81\oo4o

SOFTWARE\ORACLE\ORACLE_HOMES

SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE1
ORACLE_HOME = D:\oracle\Dev2k
ORACLE_HOME_NAME = Dev2k
ORACLE_HOME_SERVICE = Dev2k
SHARED_ORACLE_HOME = D:\oracle\Dev2k
API = D:\oracle\Dev2k\DBS
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
COMPANY_NAME = Republic Windows & Doors, INC.
ORACLE_GROUP_NAME = Oracle for Windows NT - Dev2k

SOFTWARE\ORACLE\Workflow
Icon Directory = D:\Oracle\WF\ICON
Level = d Version = 2.6.2

SOFTWARE\ORACLE\Workflow\Font

SOFTWARE\ORACLE\Workflow\Languages

--- Path ---

D:\Oracle\bin
o:\xbn8
C:\Program Files\Oracle\jre\1.1.8\bin
D:\oracle\Dev2k\bin
D:\oracle\ora81\bin
C:\Program Files\Oracle\jre\1.1.7\bin
C:\WINNT\system32
C:\WINNT
C:\WINNT\System32\Wbem
D:\oracle\Dev2k\jdk\bin
C:\Program Files\Common Files\Autodesk Shared\
Z:.
Y:.

--- TNS names ---

If you need to see this section, I can supply it to you directly rather than in a public forum. THanks,

rw