Recent content by kctx7

Would anyone be interested in integration to "ANT": the java build program? We're using it to build PL/SQL now, so I've made a plug-in that lets you launch ant easily from within PL/SQL developer. If there's enough interest, I'll see if I can contribute it. The other tools I've done so far...

Would you know if the VCS plug-in can be made to work with CVS as well? ----------------- ----------- Compassionate Liberals? http://209.157.64.200/focus/f-news/1278180/posts

Would there happen to be any undocumented features in the plug-in interface that would let me know when someone clicks a button like the "+"? I've tried OnPopup and OnMainMenu: no luck...

Roberto, You should be able to use PL/SQL functions like XMLElement, XMLForest, and XMLSequence to formulate your data into a single XML column. PL/SQL Dev can be used to export the data if you want, but its XML capabilities are mostly for extracting and viewing data. Kerry

We had problems with XMLType columns and I ended up creating a view that implemented xmlcolumn.GetStringVal() for the xmlcolumn, then translated back using the XMLType constructor in an "INSTEAD OF" trigger.

Anyone out there who would like to learn to program PL/SQL Developer's plug-ins, but doesn't have the tools from Microsoft to do it (and maybe like me doesn't want to learn that stuff)... You can very EASILY compile a .DLL in CYGWIN and I'm already using some DLLs built this way as plug-ins...

That's one thought we've had; I can almost program that as a plug-in. A plug-in can execute the query in a window, so all I need is to tie into the event of clicking "POST". Unfortunately I don't think I can do that. Another small problem with this approach would be that the rows might get...

We have non-programmers using PL/SQL developer to do data input. When they enter data into the result grid, sometimes they must specify new keys from a sequence. Is there are straightforward way to have BOTH: the new sequence is assigned automatically, AND: the newly assigned number shows up...

Anybody have a great solution for database builds? We wish to keep all of our database objects (views, PL/SQL, triggers, types...) in source code control and allow developers to build their own copy of the schema. Right now we use Sql*Plus to script the build, but it has many problems: error...

Our Oracle servers run on Unix systems, and we do our QA and productions builds of our web, java, and database code all on the Unix (linux) systems. We check in all of our pl/sql, tables, views, etc. from PLSQL Developer into CVS, and the build pulls them from CVS. We use SQL*Plus on the unix...