Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replace chr(0) in old Oracle Client Command

mpatzwahlMay 29 2020 — edited May 29 2020

Hi,

i have a strange Problem: I´m using a very old Oracle Software (20 Years old) together with Oracle 18c XE

90% is working very well, but the Sotware uses the Following Command:

SAVEPOINT FM_1

followed by chr(0)

How can i replace chr(0) from the command (send by a old Forms 60 Client)

I tried:

exec dbms_sql_translator.create_profile('FORMS60', TRUE);

BEGIN dbms_sql_translator.register_sql_translation(

  profile_name    => 'FORMS60',

  sql_text        => 'SAVEPOINT FM_1'||chr(0),

  translated_text => 'SAVEPOINT FM_1');

END;

ALTER SESSION SET SQL_TRANSLATION_PROFILE = FORMS60;

ALTER SESSION SET EVENTS = '10601 trace name context forever, level 32';

But it seems not to work with SAVEPOINT Commands.

Has anybody an idea, how i can get rid from this chr(0) ??

Thanks

Marco

Comments
Post Details
Added on May 29 2020
6 comments
212 views