Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_PIPE
DBMS_PIPE [message #322119] Thu, 22 May 2008 09:50 Go to next message
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 #322125 is a reply to message #322119] Thu, 22 May 2008 10:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above


>Our developers say that there is a error in this package.
Error? what error? I don't see any error.
Re: DBMS_PIPE [message #322126 is a reply to message #322119] Thu, 22 May 2008 10:01 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Please frame a query for this
Next Topic: Archieving and deleting
Goto Forum:
  


Current Time: Sat Feb 15 12:12:32 CST 2025