Recent content by Karthi S

Hello there, I have been using PLSQL Developer 12 for a few years now. I remember that when I copied the SQL from the SQL window and pasted it into a new Outlook email draft(in HTML format), the SQL was getting pasted with proper format (same font, text color etc., that I see in SQL window is...

Thanks for your response. I see "Check Connection" checkbox and I have it enabled. But then I dont have "Check all sections". But still my session is getting timeout. Please note: I am using PLSQL Developer 12.1.

Hello there, I am using PLSQL developer 12.1. The user ID that I used to connect to the database has created a timeout after a specified idle time. Is there any setting or option to avoid such session timeouts in PLSQL developer? Thanks.

Hello there, When I execute the PLSQL block in SQL window which has DBMS output text, it wipes previous DBMS output and displays only the output of most recent execution. Is there any setting where we can keep the old output retained and the new output is added at the end (even if the new...

Hello there, I am using PLSQL developer 12.1. Whenever I use "Copy to Excel" function in SQL window, I see the first column has row numbers from 1 .. n. Is there any setting to avoid that column? thanks.

Hi Marco, Thanks for your response. Yes, I realized there are special characters. That's why those quotes are getting added. Once I removed those special characters it looks good when I copy and paste the SQL results to a text editor.

Hello there, I am using PLSQL developer 12 version (12.0.7.1837). When I run some select SQL in the SQL window, I get the SQL output in the grid. But when I copy the rows and paste into any text editor, each line from the grid is getting paste in a strange format. It is adding a double quotes...

Hello there, I joined in a company where the user name I use to connect to the database has "select catalog role" granted with no default option. so every time, before I execute some SQLs that uses some DBA_ objects, I first need to execute "set role all" for each window (as i use multiple...

Hi Marco, unfortunately i can't send you the code, but it's weird that i am able to compile the same package with "safe compilation" enabled. One thing i could think is: we had some patch applied in our TEST database and DBAs mentioned we had some issues with dba_source. May be they fixed it...

Hi Marco, Yes it worked and i did mentioned in my post. but my concern is now i lost the ability to do safe compilation. so just wanted to understand why it was working all along and stopped working now and how can i enable the "Safe Compilation" again? thanks, Karthi.

Hi there, I am using PLSQL developer 11.0 and when i try to compile a package spec/body from program window, i was getting following error. but when i disabled the "Safe Compile" preference, i did not get that error and i was able to compile from program window. Can you please explain why it...

Hi Marco, Any TEXT that I selected in SQL window or command window or program window. For example: assume i have insert SQL with SOME TEXT being inserted into varchar2(30) column.. and If want to check the length of the string that is being inserted then, any chance to quickly know the length...

Hi Marco, When I tried that SQL in SQL window, I do see "dba_tables" in one database(B) and not in another database(A).

Hello there, Do anyone know about any plug-in or work around to see the length of the selected string in PLSQL developer 11.1? Thanks, Karthi.

Hi Marco thanks for your response. I have "use DBA views if available" is enabled, in fact in the same single instance of PLSQL Developer, when I connect to Database(A) - i dont see "dba_tables" populated by code assistant when type "dba_", but when i connect to database(B) from the same...