The problem is not directly in my plugin.
I send pl/sql dev something like "SUBITEM=Tables liées" for a menu item.
The menu item isn't correctly shown, bad chars are display instead of é.
i thought IDE_PlugInSetting function can make pl/sql dev could my menu item correctly.

0xC3 0xA9 is the correct UTF8 encoding for é. See also https://www.compart.com/en/unicode/U+00E9.

You may need to convert from UTF8 to a character encoding that can be displayed in your Plug-In.

instead of é, i obtain é.
It's 0xC3 0xA9
it's the same chars in my dll,

In our own Plug-Ins we call this in the OnActivate function. If you set the mode to UTF8, what exactly is displayed for characters with an accent?

I tried to call
bool = IDE_PlugInSetting(PLUGIN_ID, *"CHARMODE", *"UTF8") in OnCreate function.
But string with accentued char are not shown correctly.
Is it the correct way to call this function?

I added some debuglog and obtain a PlugIn Exception.
i have to look further.

OnCreate is not the good place to call IDE_PlugInSetting, RegisterCallBack was not call.

I put the call to IDE_PlugInSetting in then OnActivate function, it seem to work fine but, strings are not correct.
in debug.txt :

IDE_PlugInSetting(CHARMODE, UTF8) [Rust plsql plugin version 1.0]
IDE_PlugInSetting: OK() [Rust plsql plugin version 1.0]
IDE_DebugLog() [Rust plsql plugin version 1.0]
Plug-In: Appel IDE_PlugInSetting : OK


i tried the three options; but none works.

I tried it yesterday before I posted but it did not help.
However I tried it just now again and it's OK now.
In any case I think the default for new windows should not be any "open" workset. If I need to open a workset I can always open it when needed.
I hope it does not happen again because it was solved in a way I don't understand...

gad

after some hours, i have finally found a solution to my problem.
i found a library (crate) to convert my string (textcode::iso8859_15).
I can after easily send my string to pl/sql dev.

I wil try to use the function IDE_PlugInSetting, to see if it's a better solution.
Thanks.

Does it help if you close the workset (File > Workset > Close) after step 2?

Perhaps you can use the CHARMODE Plug-In setting?

Hello,
When I'm opening new plsqldev instance:
1. I cannot access any field in the login dialog (like user name) . All fields except password are greyed and contain whatever was there in the previous login.
2. After I enter the password the instance window opens with a title of one of my worksets. Usually it opens with the connection name only. The workset itself does not open.
3. If I open a project in this instance the files of the project do not open automatically like always. When I close the project, the project files do not close automatically, like always.

How can I reset this annoying behavior?

Using pl/sql dev 15.0.1.2051 32 bit.

gad

Hello,
i'm learning Rust for myself, so i decided, as an exercice, to develop a plsql developer plugin.
I created all the necessary functions to make my dll reconize.
Add more functions, to make a basic plugin, create menu, windows ...
Most of function for my use was created.
My code is certainly no perfect, but everything works.
But i have a problem i can't resolve for now.
Every string in Rust are save in UTF-8 format, So when i pass it to PLD, accentued char are not represented correctly.

Is there a way to pass UTF-8 string to pl/sql developer?

If someone using rust to, is there a way to convert utf-8 string to iso-latin or someting else, reconized by PLD?

I have no problem with a C++ plugin.

Thanks

To indent the text you can mark it and press <Tab>.

Thanks for your response. Yes in SQL editor. Suppose I have a large sql and if I want to tab or space all line together do we have any easy options other than cut-paste.

Thank You

I have added this to the list of enhancement requests.

If you have a query like:

with some_CTE as
(...)
select [some_columns]
from
(select [columns]
from complicated query
join some_CTE on ...)

then using either version of Export Results you cannot export the data as a SQL file (or to clipboard as a SQL file) I believe it is because the export process is unable to figure out what you want the target table to be, as in :

insert into [some target table] (FILE_NO, BENEFIT, AMT_3YRS, LAST_DATE)
values (728833, 'Non-medical Transportation-Household Moving and Storage-In District', 958.15, '2024-01-21');

Using a SQL file was by far the easiest way to accomplish what I needed (transferring data from Oracle to SQLite), and the only way I could do this was to save the results to a temporary table using CTAS and then select from the temporary table and create the SQL file from that. Moving the CTE into the query didn't help.

Apart from the fact that it took a while to figure out what was going on (the export just does nothing; doesn't pop up an error message), it would be much more sensible to ask for a name for the target table when it cannot figure it out.

Jon

Indeed. This is not what I intended to imply. As stated: we're looking into the option for a clang package (Windows 64-bit Modern platform).

My question concerned the Windows 64-bit Modern platform. This is definitively not binary compatible.

Markus

RAD Studio 12.1 is binary compatible with 12.0, so you can install the current RAD Studio 12 packages.

We're looking into the option for a clang package (Windows 64-bit Modern platform).

Do you mean the text editor? If so: select the lines, press Ctrl-X to cut them, go to the new location, and press Ctrl-V to paste the lines again.

Will DOA support C++ Builder 12.1, especially the modern clang compiler?

Best regards,

Markus

Hello,

How to move multiple rows in Editor?

Version is : 15.0.0.2500

Thanks & Regards,
Punit

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.