Home » SQL & PL/SQL » SQL & PL/SQL » Successful or not...
Successful or not... [message #38385] Tue, 16 April 2002 06:43 Go to next message
Lissa Wong
Messages: 4
Registered: March 2002
Junior Member
How do I know whether adding new record to a table is sucessful or not? And how do I display that status message (Successful or Unsuccessful) to the user in PL/SQL Sever Pages?

Report message to a moderator

Re: Successful or not... [message #38389 is a reply to message #38385] Tue, 16 April 2002 07:14 Go to previous message
Nithya Natarajan
Messages: 2
Registered: April 2002
Junior Member
You can check with the following statement:
if sql%rowcount = 0 then return 0;
else return sql%rowcount;
end if;

Thanks
Nithya

Report message to a moderator

Previous Topic: Problem related to ref cursor and collections
Next Topic: increasing the screen width........
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 16:06:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.