Bug in dbms_hs_passthrough with TCL in Oracle 19
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0
I think there is same bug in using dbms_hs_passthrough with TCL commands.
@aus5d points to mariadb using HS.
select * FROM cdr_data@aus5d;
works fine.
But below code:
declare
curs integer;
pstmt clob := to_clob('
select * FROM cdr_data t
WHERE date_format(create_time,''%Y-%m-%d %T'') >= ''2021-04-29 00:00:00''
AND date_format(create_time,''%Y-%m-%d %T'') < ''2021-04-29 01:00:00''
');
begin
curs := dbms_hs_passthrough.open_cursor@aus5d;
dbms_hs_passthrough.parse@aus5d(curs, pstmt);
commit;