Recent content by Dave Sharpe

Great Marco Thanks as always

I experienced problem exporting to excel. Excel never opens no error NO lockup. After restarting Developer a few times and rebooting PC a few times I did experimentation; reducing the export to individual fields/columns and localized it to just one. Via substr testing on that field I found the...

Marco - I understand, thanks for the prompt reply Dave

Marco - Any progress on the question of exporting more that 65K rows? I was hoping to use larger export size as a reason for getting office upgrade authorized. Thanks Dave

Thank you Marco.

I find great benefit using ExamDiff. I did some looking, and the version I have in my PL/SQL developer file seems to be ExamDiff(TM) Version 1.6e. I found ExamDiff on the web and it has evolved a bit since version 1.6e (http://www.prestosoft.com/edp_edhistory.asp). Is there any known downside...

Claus Thanks for getting involved. Your reference to 'indirect' code is news to me. Could you perhaps take a small snipplet of my "indirect" code and supply the code or psudocode using the perfered methodolgy ? Thanks Dave

I love "GLOBAL TEMPORARY TABLEs" (GTT). I have been using them for awhile, and find them to be a great tool. We are rac'ed but I am logging into one specific instance. My developer is 7.1.2 and is configured for "Dual Sessions". I am working on a new package that utilizes three GTTs and all...

Thanks Marco. One of those times when one's prayers are answered (but the answer is no)

Then testing ( function or procedure ) should the "Large Data Editor" launch when I have a variable whose value is large. Mine doesn't, I just get "(Long value)" and am lost. If it should is there something I may have done to prevent it ? If it shouldn't, is there a way to configure and...

Please disregard. I seem to have found my problem. For Version 7.1.1.1339 I have an AfterConnect.sql file and it included an invalid default date format. It operationally caused no problem till I used this one procedure written by someone else. I regret any inconvience that I may have caused...

I searched the formun and did not find an existing post on this subject. I have a good sized procedure with 20 parameters and it returns a refcursor. When I do a "test" on it using Version 7.1.1.1339 I get the error "ORA-0186: literal does not match format string" in the message area at the...

Marco I've a problem running a pkg made by a co-worker that hasn't upgraded recently. As a test we'd like to put a 6. version on my PC. I don't see one available under downloads, will make it available to me? (or just point me to it) Any problem having both on the same PC? Thanks Dave

As always, thanks Marco Dave

I have Version 7.1.1.1339 My default return rows is 1000. If (actually when) I ask to Copy to Excel and I haven't yet retrieved all rows, I get a msg box alerting me to my mess up ("Note, not all records are fetched"). It however gives me no option to get them all (Okay and 'X' neither seem ot...