sql server programming: Packaging stored procedure -- sql server programming

Re: Packaging stored procedure

MAS
11/21/2004 2:25:02 AM

Uri,
Actually no. What I'm trying to do is to group a set of procedures in a
single package. This package will have global variables than can be set and
used by the package stored procedure

[quoted text, click to view]

Re: Packaging stored procedure

Uri Dimant
11/21/2004 12:00:42 PM

MAS
I am not familiar with Oracle. Are you talkin about to run the DTS package
from stored procedure that is accepted a parameter for global variable?

[quoted text, click to view]

Re: Packaging stored procedure

Uri Dimant
11/21/2004 1:34:17 PM

I see what you mean
I know you can use SELECT col FROM Table WHERE col=? to use a global
variable.
I did not ny myself to use EXEC sp ? and I am not sure , but you can visit
on this web site to find out how to use a global variables within DTS
packages
www.sqldts.com

[quoted text, click to view]

Re: Packaging stored procedure

Tibor Karaszi
11/22/2004 1:55:03 PM

There is no such things as Oracle Packages in SQL server. In a SQL Server database, you can have a
number of stored procedures. You might be able to use some naming convention to separate logically
grouped procedures from another. But that is about it, I'm afraid.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.