Solved

How can I execute this package?

Posted on 2003-10-21
3
4,797 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
add more rows to hierarchy 3 48
subtr returning incorrect value 8 101
PL/SQL: ORA-00979: not a GROUP BY expression 3 83
SQL query to select row with MAX date 7 69
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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 shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

752 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