ORA-01858: a non-numeric character was found where a numeric was expected ORA-01858: a non-numeric character was found where a numeric was expected The temp table column datatype is DATE Include a ...

We have a stored procedure with OUT parameter REF CURSOR. When we had aroud ~1k records returned performance was good enough. Now it goes beyond 140 seconds with 50k. While executing the same ...

David Litchfield's ongoing assault on Oracle databases has unearthed a new method of exploiting PL/SQL injection vulnerabilities. Litchfield, co-founder and managing director at NGSS (Next ...

Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ...