Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL
PL/SQL [message #261592] Thu, 23 August 2007 01:54 Go to next message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
Hi All,

I have create two proedure for mailing purpose but i want when no data is found agains the user name then no mail sent to the user but in this case also send a mail to user with heading without data, please help for the same details attached in file
with (table script, data and procedure).

File name : help.sql

Regards,
Arvind
  • Attachment: Help.sql
    (Size: 659.72KB, Downloaded 665 times)
Re: PL/SQL [message #261610 is a reply to message #261592] Thu, 23 August 2007 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't read the file as with 660KB I know there are surely thousand of lines or this is not a real script file, anyway I can't download it. Post something that is readable.

Regards
Michel
Re: PL/SQL [message #261617 is a reply to message #261610] Thu, 23 August 2007 02:29 Go to previous messageGo to next message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
Hi,

I have attached the original script file......


Arvind
  • Attachment: Help.sql
    (Size: 47.47KB, Downloaded 209 times)
Re: PL/SQL [message #261621 is a reply to message #261617] Thu, 23 August 2007 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
770 lines is too long for me.
Maybe someelse will not be so lazy and read your file.

Regards
Michel
Re: PL/SQL [message #261687 is a reply to message #261617] Thu, 23 August 2007 06:09 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
I had a look too and agree with Michel. Far too much code. Follow Michel's suggestion and post a cut down version.
But as a hint you might look at a conditional block based on cursorname%NOTFOUND
Re: PL/SQL [message #261900 is a reply to message #261687] Fri, 24 August 2007 00:30 Go to previous message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
ok working
Previous Topic: JOIN USING
Next Topic: PL/SQL Procedure
Goto Forum:
  


Current Time: Tue Dec 06 00:29:56 CST 2016

Total time taken to generate the page: 0.27866 seconds