Oracle timed task Job call stored procedure has back output parameters (with out parameters)

Source: Internet
Author: User

Oracle timed task Job call stored procedure has return output parameters (with out parameters)

Because the foreground invokes a stored procedure that contains out parameters, it also wants to invoke the same stored procedure in the job, and does not want to remove the out parameter and re-build a stored procedure to be called by the job.
Although the out parameter does not have any meaning in the job, the following method is used to define the parameter variables before calling the stored procedure, considering that the program is the most simplified and does not duplicate the construction. The following s1,s2 are out parameters, we hope to help you.
Begin
Sys.dbms_job.submit (Job =: Job1,
what = ' declare s1 VARCHAR2 (200); S2 VARCHAR2 (200); Begin P_test.usp_test_jobincs (S1,S2); End; ',
Next_date = Sysdate,
Interval = ' sysdate+1/1440 ');
Commit
End

Oracle timed task Job call stored procedure has back output parameters (with out parameters)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.