DBMS_PIPE [message #322119] |
Thu, 22 May 2008 09:50  |
srini_thiru
Messages: 133 Registered: May 2008
|
Senior Member |
|
|
Hi to all,
Here i have one package. Our developers say that there is a error in this package. I don't know PL/SQL. If some one can help me please analyze the script and give me wat it does. here is the package
----------------------------------------------------------------
declare
VN_result NUMBER;
VN_status NUMBER;
VN_perf_req_id NUMBER;
BEGIN
/* Start Of Profiling */
VN_perf_req_id := s_dbprofile_pkg.PROFILE_START_FUN('Start NDP');
dbms_output.put_line (VN_perf_req_id);
VN_result := 1;
/* Send start message to master controller */
DBMS_PIPE.PACK_MESSAGE(1);
VN_status := DBMS_PIPE.SEND_MESSAGE('TOMC_PIPE');
dbms_output.put_line (VN_status);
/* Wait for success or failure message */
VN_status := DBMS_PIPE.RECEIVE_MESSAGE('TONDP_PIPE',20);
dbms_output.put_line (VN_status);
IF ( VN_status = 0) THEN
DBMS_PIPE.UNPACK_MESSAGE(VN_result);
dbms_output.put_line ('if: ' ||VN_result);
END IF;
-- /* End Of Profiling */
s_dbprofile_pkg.PROFILE_END_PRC(VN_perf_req_id); --end profiling
dbms_output.put_line (VN_result);
end;
-------------------------------------------------
Please help me. I don't have idea in PL/SQL.
Thanks in Advance,
Seenu
|
|
|
|
Re: DBMS_PIPE [message #322126 is a reply to message #322119] |
Thu, 22 May 2008 10:01   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Your developers say it's broken, you don't know PL/SQL, so you accept the task of fixing it?
Does not make sense to me.
|
|
|
Re: DBMS_PIPE [message #322436 is a reply to message #322119] |
Fri, 23 May 2008 09:35   |
srini_thiru
Messages: 133 Registered: May 2008
|
Senior Member |
|
|
Hi,
The output of that query returns -1. But what our developers say means it must return either 0 or 1. We have to make changes according to that.
The Reason why i posted here is i don't know PL/SQL.
Thanks & Regards,
Seenu
|
|
|
Re: DBMS_PIPE [message #322449 is a reply to message #322436] |
Fri, 23 May 2008 10:20  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
I am really sorry, but this is not a post-your-code-and-we-will-fix-it-for-free site.
The intention of the people here is to help others our with specific problems they have. In order to be able to do so, a set of guidelines is set up to improve the chances of getting a useful answer.
You should provide more info, you should show us what you tried to fix it, and where you got stuck.
If you really don't know pl/sql, you should hire someone who does.
|
|
|