-
Titel
The entry "COMMIT ON RETURN YES" missing from the script. -
Beschreibung
Create a store procedure with the script below:
CREATE PROCEDURE RKENNEY.TEST ( ) LANGUAGE SQL DETERMINISTIC COMMIT ON RETURN YES NO EXTERNAL ACTION READS SQL DATA CALLED ON NULL INPUT INHERIT SPECIAL REGISTERS NEW SAVEPOINT LEVEL pp: begin return 0; end pp;
After disconnect Toad and reconnect, it's display the script below in the script tab or when export the ddl:
CREATE OR REPLACE PROCEDURE RKENNEY.TEST ( ) SPECIFIC SQL140902115200941 LANGUAGE SQL DETERMINISTIC NO EXTERNAL ACTION READS SQL DATA CALLED ON NULL INPUT INHERIT SPECIAL REGISTERS NEW SAVEPOINT LEVEL pp: begin return 0; end pp;
The "Commit on Return Yes" is missing.
Anmeldung erforderlich
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.