First time while registering the concurrent programs we forget the 2 mandatory parameters. After the error we can know that we need to you those mandatory parameters those are ERRBUF and RETCODE.
These are really good if you use properly.
ERRBUF: It return the error message. For you program if you get any error in exception block you can assign the error message to this parameter. This error message you can see after concurrent program run go to details button it will open details in that Completion Text filed will show your errbuf.
RETCODE: This parameter returns the status of the concurrent program.
0- Success --Completed
1- Warning -- Yellow color
2- Error -- Red
These parameters we call as a first parameters for the program.
Ex:
Create procedure concurren1(ERRBUF out varchar2, RETCODE out varchar2, v_order_id in varchar2)
Imortant Note:
If you register a PL SQL program as a concurrent program, call the program from another PLSQL, then the error message or any message can not be returned to the calling program. Program can only return the status of the program.
No comments:
Post a Comment