PL/SQL (MOSC)

MOSC Banner

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;       

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center