Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Connor McDonaldQuery 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...
Connor McDonaldComplete 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 ...
Chris SaxonSelect 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...
Connor McDonaldIn 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 ...
Tom KyteHow 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...