Recent content by geraldwinslow

OK, well, I did end up doing just that, plus granting on v_$ to the regular account. But, I thought there might be a more streamlined way of doing that. And the PLSQL Dev. help file was no help in this situation, though it did mention that the user should have EXECUTE on dbms_system, which...

Sirs, I'm sure there's a simple solution to this - When logged in as a 'regular' user and I bring up the Sessions window and click on my session, in the tabbed sections below, I get this: ORA-00942: table or view does not exist When I connect as a DBA and do that again, I see actual data...

I really like the Recall Statement capability. Is there a limit to the number of SQL statements it will save? Is that limit configurable? Thanks, Gerald

Thanks, it will be greatly appreciated. Gerald

I'd like to be able to, within one instance of PL/SQL Dev, be connected to multiple databases at the same time. I have data and code residing in multiple databases, and I don't like the restriction of having only one active connection. This is pretty important to me, and would save me a lot of...

Thanks for implementing this. I was just about to make a request for WHERE clause cleanup in the Beautifier when I saw this thread. I look forward to seeing this feature. Gerald Winslow

In the debugger, I'd like to be able to sort the variables in the watch window. Currently, they appear in the order that I add them, top to bottom. I would like to sort them by variable name. Thanks! Gerald

I'm debugging some PL/SQL and stepping through my code with the debugger. When I find an error in my code, I exit the debugger using the break button, update my code, recompile my source, and rerun the debugger. But, when I start stepping again through my code, the debugger shows me the "old"...

Thanks! Amazing how easy it is! I guess, that's Delphi for you!

Sir, So InternalQuery is a "property?" Can I do what you suggest without the DOA source code? I'd like to try this, if possible, but have never derived a new component before. Could you give a brief example? Thanks!

Can anyone tell me how to get the function type from a TOracleDataSet's TQuery part? Thanks! Gerald Winslow

Folks, I'm wanting to keep an Oracle connection alive through a firewall. My solution is to periodically (every few minutes) query the database in background with "SELECT 1 FROM dual". Does this sound like a good idea, or is there some better way to keep a connection alive? Thanks! Gerald...

Sirs, I have developed Oracle applications that do not use any data access components, just standard "string" Delphi components. As such, it seems unnecessary (from my perspective) to require Delphi Prof. as a minimum. I understand that there are some data components necessary to make *all*...

I assume that DOA requires the Delphi 5 & 6 Professional versions so that developers can use the data components included with the Professional versions. However, it is possible to create DOA applications that do not use those components, only the standard Delphi components. So, why not allow...

Actually, I did it in Delphi, passing the date column using FieldAsDate() to the Delphi FormatDateTime() function. Thanks!