PL/SQL Developer version 8.0.2.1505.
Seems like breakpoints don't work with non-packaged functions and procedures. When I clicked on run to next exception tests finished without running to it.
I tryed to load file into DB via TLobLocator.LoadFromFile.
When I use path like "\\servername\dir1\" it is ok.
But when I connect this path as network drive LoadFromFile fail.
What's the problem? I need to add this path via "create directory" SQL? Or maybe it is a security issue?
i often use collection in PL/SQL code.
When i debug functions in packages i wanna to see what is in collections, but i can't. Neither "count" property, nor something like this: "(.last)". Only ".(x)", where x is fixed number value are work.
My suggestion about this limitation is because...
I set up mouse to scroll 10 lines at time, but in PL/SQL Developer's code SQL window it scroll only 3 line at time.
Is this is bug?
Or scroll speed is always 3? If always 3, is it possible to amke scroll speed as editor option in preferences?
Is it possible to intercept "ORA-04068: Existing state of packages has been discarded message error" with components?
If no, think about this suggesction:
add "InterceptExistingState" property (type boolean, default = True) to TOracleSession.
When it set to true and when some action return such...
There is intrestiong BUG in DOA 4.0.7:
TOracleDatabase connects to DB from design-time, but in run-time excepts message:
"ORA-12154: TNS: could not resolve service name".
Problem is.. left bracket "(" and right bracket ")" in path to application's exe. When this symbols are deleted from path...
We have 2 types of forms in project:
ordinary forms and runtime-generatend (from .dfm-files which are stored in DB).
When i (on ordinary form) remove field description from a Fields Editor in Delphi and add it back it works! No errors with this form. But there is a big trouble to do like that...
I'll use following settings in Session:
FloatPrecision = 0,
IntegerPrecision = -1
SmallintPrecision = -1
So all NUMBER fields in DB are interpreter as Float.
That's ok for all fields except one with "NUMBER(1) nullable default 0". On this field raised Delphi Exception "Type mismatch expected...