Ask The Oracle Mentors

Recently Answered

	Query never finish without clear reason Some times an aleatory select statement stop working without a clear reason.Some times the statement is inside procedure, some times it is executed directly from ODAC FOR .NET 4Then only thing in common it was always executed by ODAC client, so I never got thi...
	Complete transient session for testing We have looked at dbms_flashback and dbms_wm but both don't deliver what we actually want: Is there a possibility to make an entire session transient?We would like to use this for our testing scenario's:1. Start the session in "transient mode"2. execute ...
	Select for update statement too slow Hi Connor, Chris,I have a FOR UPDATE SQL used to lock certain rows in ORDERS table but it seems to be bit slow (takes around 1 min).I tried getting plan from dbms_xplan.display_awr. Could you please give me some lead from your past experience and I can look fo...
	In database row archival I do have a question about Oracle Indatabase archiving in Oracle 19c,given below table has a XMLtype columnalter table HTS_SUMMARY_DATA_CELL row archivalError report -SQL Error: ORA-38353: This table type is not supported by the ROW ARCHIVAL clause.This error ...
	How can I do a variable "in list" I have a simple stored procedure, that I would like to have a passed in string(varchar2) for used in select from where col1 in (var1) in a stored procedure. I've tried everything but doesn't work. Followed is my proc. Thanks CREATE OR REPLACE PROCEDURE WSRE...