Recent content by Sean_UK

Solved for VBA (and presumably something similar for VB too). For anyone that might have the same problem, the reason my VBA code was not returning the data was because I was using a Microsoft providor instead of the Oracle one (MSAORA.1 instead of OraOLEDB.Oracle.1). Switching provider then...

OK, solved! My Oracle Home was pointing to the Default Home, which was using an Oracle install of version 8. So PL/SQL was happy with the query, the database (v10) was happy and returned data, but somewhere along the line the data wasn't getting shown by PL/SQL developer. I guess the version 8...

Thank you, that's a good start. So at least now I know it's something in my set up, rather than a software limitation. I'm using 7.0.3.1123, but I don't imagine the version difference would be that significant. I don't suppose you have any idea whether this would be due to settings within the...

Hi, I have been writing queries that contain a factored subquery, like: WITH My_Table AS ( SELECT * FROM Table_Name ) SELECT * FROM My_Table This works when using SQL+, but not when using PL/SQL developer. Does anybody know if this is a limitation of the software, is it a setting within the...