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