SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
packages in sql server 2000

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
packages in sql server 2000
Author Message
Amit



Joined: 30 May 2005
Posts: 2

Post packages in sql server 2000 Reply with quote

How do I call a package from stored procedure?

Mon May 30, 2005 5:56 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Re: packages in sql server 2000 Reply with quote

just like any other stored procedure just prefix it with a package name, for example

CREATE PROCEDURE blah_blah_blah(proc parameters here)
BEGIN
--- some SQL
--- ...
--- call packaged stored procedure
DB_MAIL.CREATE_MAIL_FILE(proc parameters here);
--- call packaged function
ret_code := DB_MAIL.SEND_FAX(fax parameters here);
END;

: How do I call a package from stored procedure?

Mon May 30, 2005 10:02 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.