Recent content by tcogill

I'm having this issue also. As a work around I've started quering all XMLType columns like this: select col1, col2, col3, xmlserialize(content xml_col as clob) as xml_col from any_table; I'm on Oracle 11.2.0.3.0, PLSQLDeveloper 9.0.5.1648. A coworker is also seeing this on 9.0.6.1665...

I'm still at a loss as to why, inside a Test Window, cut/paste a string into my CLOB parameter doesn't work, but here's my work-around for anyone interested. The theory is since this is development, store my long string(XML) in a table then select it out from with my Test Window. The actual...

I didn't realize there was a difference. The application that uses this works fine (and has been for a while), I've been tasked with a few enhancement requests. The original developer did not use PLSQL Developer to test. Here's my procedure spec (if it helps). procedure saveEmp ( p_token...

Be careful what you wish for, you might just get it. If this feature is added, could you also add a Preferences option to turn it off? - Tim

I have a procedure that accepts a CLOB parameter, into which I am sending and XML string. In the debugger variable pane, I select "..." for the parameter to open the Large Object Editor. I cut/paste the string into the Text tab; the Editor recognizes it as XML and allows me to see the parsed...

Thanks!

I've found a difference in behavior between a Command Window and SQL*Plus: Assume these files exists... c:\database\main.sql c:\database\sql\test.sql test.sql contains a simple select > select 'test' from dual; main.sql contains a call to test.sql > @@.\sql\test.sql Any thoughts as to why...

Sorry if this is a duplicate, I didn't see one in the forum. In past versions, all editors acted much like other Windows (Microsoft) products with the ability to CNTRL + ArrowLeft or ArrowRight to skip to the beginning or end of a word. With a fresh install (new laptop) of the most recent...

Check out this list of comparisons... http://www.orafaq.com/tools/table.htm It's been my experience that TOAD has many DBA-ish functions, while PL/SQL Developer is more geared towards development. There is a lot of overlap in functionality. For point #2, be careful what you wish for. I've...

All - We have this same "internal error" problem. It's actually a bug in Oracle9i that has issues around using cursor%rowtype variables. Oracle said it will not be fixed until the next patch... in February. The work around is to define your cursor in the package specification instead of...

As Marco mentioned, this is an Oracle _feature_ and simply how dbms_output works. As a possible work-around/solution, try creating a logging routine that writes messages to a table. Then instead of using dbms_output, call this procedure. Utilize autonomous transactions to commit the log...

Is this request for PLSQL Developer or Oracle? In order to get this functionality in Oracle we created a "database_common" package that contains constants and common functions. All other packages/routines can reference that. Not as slick as C includes, but gets the job done.

It's extra typing, but if you put "WHERE 1=1" on your statement, that pop-up will not appear.

OK - the real issue was a misunderstanding of how the Browser Extender really worked. After email tag with the developer (thanks Joachim), here's the skinny: "In Configuration window you can see an Actions page. This page defines two events (actions): onClick and onPopup. => onClick means that...

Good thought. I disabled my Browser Extender plug-in and get instant response from the right-mouse-click. Even with a new download, same slowness. Guess I'll let Joachim know. Thanks! - Tim