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.
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center