Recent content by herzig

Like stated by Hilarion, PATH Settings are responsible for oracle client selection. I didnt test this, but idea to be able to use either oracle installation would be to simply call plsd form cmd box after setting/changing preferred (bin) oracle client path inside there. Perhaps useful for...

Oh, maybe You got me wrong. I did only suggest this behavior and described it similar to we do it with our own applications. In short, on top of plain Excel Export PLSD needs this function: "Export using [this]Excel Template" Where [This] can be choosen out of PLSD preference set. After fill...

I would appriciate something like that. In our apps we have solved it this way: Data is not opened in new, empty worksheet, but (selectable) "hand-made" template, including save macro and some cell function logic. save macro looks to specific (named) cell, which again can hold typical excel...

This is perhaps BOM to sign file content as unicode. Don't know what triggers PLSD to do that. Maybe unicode charcters in database object scripts?! Anyway, what vcs / editor are You using? VCS shoouldn't care about that and "modern" editor same.

If You do not want the clicky way, maybe You need something like this, which nearly works in PLSD, except "trimspool" is not supported in command window. Its made for sqlplus: -- paste below in command window / sqlplus set colsep | set pagesize 0 set trimspool on -- doesnt work in plsd set...

Hi! I run into trouble with undo/redo on 9.0.2.1640. Although the running instance continues messy undo/redo changes, I can't reproduce that in new instance and I can't remember how I got there. Basically I have a "large" (215 KB) sql file holding view definitions and a bunch of other windows...

If there should be a default autosave desktop, then I suggest to give names for different layouts. So user is able to store different layout for certain projects, for debug, etc.. and finally have one fix-named "autosave" item, which is automatically restored on startup.

Already tried to search the net? simple one e.g. here:http://www.orafaq.com/wiki/PIVOThttp://www.orafaq.com/wiki/UNPIVOT

Hi Dirk, to me everything is perfect with schema handling like it is. And I see no changes in latest PLSd. I load and compile scripts without schema definition every day. Testing /Debug only works on compiled objects, which have to be bound to a schema. I don't see any problem with that.

May be you could add additional brakets around the whole expression and add column alias.

I have the same problem sometimes, but it seems to appear only in large data editor / xml. PLSD is running on win7 64bit, not inside VM, but besides VM and/or Remote Desktop.

Good Idea! And if we go ahead with this idea and have a look to table items in object browser, we see beside "Triggers" just "Synonyms" and "Referenced by" are missing. Maybe these could be added as table editor tabs, too.

A refresh doesn't do..

Ok, I hope I understand it right. Then this scenario doesn't look as designed: (not sure if each step is necessary to reproduce, however..) have "Allow mutliple connections" activated on PLSD ..1620 have "Store recent history" activated have "Store with password" deactivted (all connection...

Hi, what is the meaning of this option? I don't want developers to be unaware of active connection so I never would recommend to use stored passwords. I even didn't try how it works switched to "on". Now leaving it "off" should do what? I assume staying in same window, never asks again, which...