Solved

How can I execute this package?

Posted on 2003-10-21
3
4,743 Views
Last Modified: 2008-03-17
How can I execute this package in TOAD?


PKG_SMTP_EMAIL.SEND_EMAIL
(
        'Reporting@Weightwatchers.com',
      'Reporting Server',
      PKG_SMTP_EMAIL.ARRAY('test@aol.com','test@comcast.net',
      PKG_SMTP_EMAIL.ARRAY('test@weightwatchers.com'),
      PKG_SMTP_EMAIL.ARRAY(),
      'Corporate Solutions EDI Report - PLEASE DO NOT REPLY' ,
      NULL
      ,PKG_SMTP_EMAIL.ARRAY('test.txt')
);
0
Comment
Question by:andw928
3 Comments
 
LVL 11

Accepted Solution

by:
pennnn earned 50 total points
ID: 9591387
Enclose the statement you have in BEGIN/END;
Hope that helps!
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 9591681
You cannot execute a PL\SQL package.

You can execute individual procedures or functions within a package.
0
 
LVL 5

Expert Comment

by:Pontis
ID: 9592020
begin

PKG_SMTP_EMAIL.SEND_EMAIL
(
       'Reporting@Weightwatchers.com',
     'Reporting Server',
     PKG_SMTP_EMAIL.ARRAY('test@aol.com','test@comcast.net',
     PKG_SMTP_EMAIL.ARRAY('test@weightwatchers.com'),
     PKG_SMTP_EMAIL.ARRAY(),
     'Corporate Solutions EDI Report - PLEASE DO NOT REPLY' ,
     NULL
     ,PKG_SMTP_EMAIL.ARRAY('test.txt')
);
end;
/

I'm not sure if TOAD supports it, but SQL Navigator (another Quest product) does:

execute PKG_SMTP_EMAIL.SEND_EMAIL ( 'Reporting@Weightwatchers.com', 'Reporting Server', PKG_SMTP_EMAIL.ARRAY 'test@aol.com','test@comcast.net',   PKG_SMTP_EMAIL.ARRAY('test@weightwatchers.com'),  PKG_SMTP_EMAIL.ARRAY(),   'Corporate Solutions EDI Report - PLEASE DO NOT REPLY' ,     NULL     ,PKG_SMTP_EMAIL.ARRAY('test.txt'));

0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question