Ispirer Migration Knowledge Base sqlways:oracle:techniques
https://wiki.ispirer.com/
2026-04-14T21:05:56+00:00Ispirer Migration Knowledge Base
https://wiki.ispirer.com/
https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.icotext/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle - BLOB and CLOB Comparison
https://wiki.ispirer.com/sqlways/oracle/techniques/blob-clob-comparison?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle - BLOB and CLOB Comparison
You can store text data in BLOB columns, but Oracle does not allow you to compare data in BLOB and CLOB columns without casting. You can use the CAST_TO_VARCHAR2 function from the UTL_RAW package to perform the casting.text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle - Returning Result Sets from Stored Procedures
https://wiki.ispirer.com/sqlways/oracle/techniques/result-set?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle - Returning Result Sets from Stored Procedures
You can use the OPEN cursor statement and refcursor OUT parameter to return a result set from a PL/SQL stored procedure.
Example:
CREATE OR REPLACE PROCEDURE GetOrderInfo(v_data IN NUMBER, v_refcur OUT SYS_REFCURSOR)
AS
BEGIN
OPEN v_refcur FOR
SELECT * FROM dbo.OrderInfo WHERE data = v_data;
END;text/html2025-03-04T08:59:04+00:00Anonymous (anonymous@undisclosed.example.com)Oracle - Return Application Name
https://wiki.ispirer.com/sqlways/oracle/techniques/return-application-name?rev=1741078744&do=diff
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
Oracle - Return Application Name
To return the application name for the current session, you can use the following query in Oracle:
SELECT program
FROM v$session
WHERE audsid=userenv('sessionid');
V$SESSION - system view that contains information for each database session.