Recent content by sumsar

I have viewed a function in the SYS schema and when I try to close it again I get the error: "You must keep at least one program in a sourcefile" BR Rasmus

I found this plugin. http://plsqldev-svn-plugin.tigris.org/ It seems to work, although I haven't used it very much yet.

I would also very much like theese features. :D

A new version has been released (1.4) that solves the problem. It can be downloaded here: http://www.bar-solutions.com/software/plug-ins.html :D

A new version has been released (1.4) that solves the problem. It can be downloaded here: http://www.bar-solutions.com/software/plug-ins.html :D

Thanks :cool:

Hi there Prior to version 7.1 all lines in a selection where marked with "--" when the "Comment Lines" plug-in was activated. In version 7.1 only the last line is marked. What's wrong :confused: Best Regards

Hi there How do I get the Shortcuts plug-in to work with version 7.1?? Best regards Rasmus

Hi I'm trying to define a new "session Query" that shows long running operations. My problem is that the columns seem to be sorted randomly. My select clause is: SELECT s.sid, s.serial#, l.opname, l.target, l.target_desc, l.sofar, l.totalwork...

Thanks a lot D. This was just what I was looking for. :)

How do I create a filtered list of users? I have a database with several hundreds of users, but I only want the "Users" folder to list the schema owners, in my case, users named 'P$.....' :confused: Rasmus

Thanks! Just one problem, I normally run with the browser filter "My objects", because my database is quite large. If I try to "Browse" an object in an other schema it fails, meaning I still have to select "Users//Objects/Tables/Triggers" to get to the trigger source. :rolleyes: Rasmus

What is the easiest way to view triggers on a table, when the table name is in a program window, eg. in an select clause?? Right click on the table name only allows you to view the table, not the triggers. Rasmus :confused:

Is there an easy way to compare a source script to an existing object. At least for pl/sql objects eg. packages /Rasmus

Try pasting into wordpad, save as text. /Rasmus