Recent content by RickS

Of course. Thank you.

Is there a tutorial about using the debugger someplace? I see there is a description of it here:https://www.allroundautomations.com/products/pl-sql-developer/features/integrated-debugger/ but where is the manual?

I use PL/SQL Developer to connect to test databases and production databases. I have used other tools that give you a way to make it clear when you are in production. For example, some tools allow you to make the SQL window's tab red when you are connected to a production database. Does PL/SQL...

I have noticed something new. When the "Edit column data externally as XML File?" prompt comes up, if I click "No" and I have the padlock unlocked, I am able to edit XML in PL/SQL Developer's Large Data Editor. I didn't realize that. I thought that the native editor was read-only and I needed to...

I do have the padlock unlocked, but when I save the file in Notepad++ I don't get an "Import data from modified file?" question.

It does open the XML in Notepad++ now, which is great. Thank you. The problem now is that it isn't saving my edits. It brings up a file in Notepad++ called plstemp.xml. When I change a value in the XML and save the file, it doesn't save the XML to the database. When I query the XML the old...

Yes.

The PL/SQL Developer version is 15.0.2.2054. In Windows settings, under Apps > Default Apps, I set the default app for .xml files to Notepad++.

Anybody here?

I know this is an old thread, but I'm still trying to get part of this working. When I click on the "..." next to an XMLType field in PL/SQL Developer, it says "View column data externally as Extensible Markup Language?". If I click "no" it works fine. It brings up a read-only screen showing...

I have an Oracle table that includes a column that has an XMLType data type. I store XML in that column in the table. When I "select * from" the table it shows me the rows and columns in the table. It shows the XML column as "". When I click the "..." next to it, a popup appears showing me the...

Thanks! I removed "View.xml=6" and now I get the "View column data externally as Extensible Markup Language?" popup. If I click "no" I get the desired results. Is there any way to get it to always take the "no" path without prompting me?

I wonder if when I click on the "..." on an XMLType column if PL/SQL Developer tries to open a file called "something.xml" or "something.some-other-extension". I wonder if I need to associate that other file extension with Notepad++ in Windows.

Thanks for the response! I do already have Notepad++ set up in Windows as the default way to open XML files. When I click an XML file in File Explorer, it does bring up Notepad++. Your comment helped me because I didn't realize it was talking about the WINDOWS "Default Apps Settings page". If...

I have a column in the database that is an XMLType. When I select from the table the XML doesn't appear, instead it just shows the column type, "". I clicked the "..." hoping it would show me the XML, but instead it says: What is the best way to use PL/SQL Developer with XML in the database...