Also Visit Ledger Labs provide NetSuite Services

Could it be that your Oracle user has a synonym, a view, or a table with the name V$SESSION? This would explain the different results when querying the sys.v_$session view.

Hello everyone,

I ran into a problem when I tried to do:
SELECT * FROM v$session . I get an empty value for the action field, although in fact it is not empty and ACTION HASH is not null.

If I try:
SELECT * FROM sys.v_$session, then everything is displayed correctly.

I noticed that when selecting from v$session, the 'ACTION' field type is varchar2, and when selecting from sys.v_$session type of ACTION field is varchar2(64).

Have anyone encountered this problem? I've already tried changing nls_lang, but it didn't work. The problem does not occur in TOAD.

Using PL/SQL 15.0.4.2064 64 bit,
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Sorry for bad english.

The complete Program Window will be saved, including the package specification and body if both are present in the Program Window. There are 2 solutions:

• Open the package body and specification in separate Program Windows.
• Install the "Save separate" Plug-In from the BAR Solutions web site.

Hi,

how do I only save a package body in PL/SQL-Developer ?
For me, it always saves the whole package (header and body) even when I use "Save as type: Package bodies (*.pkb)"

Thanks !

Thanks for the tip Fabrice, I have passed it on to my colleagues.

Have a nice weekend everyone
(too many configuration options are the death of the hare)

In v14, you have in options \ windows types \SQL windows, use LF as CRLF from database.
Perhaps..

Servus Marcus,


bytes - if open the Larg DATA Editor a unwanted, additional CHR(10) 0Ah is added.

Is the a Preference to avoid this?

Ahoi Daniel

... who is proud to have been using PLSQL-Developer for years