NetNews Usenet Archive 1992 #26/NN_1992_26.iso/spool/comp/database/7833

Internet Message Format | 1992-11-14 | 1.6 KB

Xref: sparky comp.databases:7833 comp.databases.sybase:310
Newsgroups: comp.databases,comp.databases.sybase
Path: sparky!uunet!devlgw!julies
From: [e-mail] (Julie Stephens)
Subject: help needed on sybase stored procedure
Sender: [e-mail] (Julie Stephens)
Message-ID: <[e-mail]>
Date: Sat, 14 Nov 1992 00:03:17 GMT
Organization: DHL Worldwide Express, Redwood City, Calif., USA
Lines: 40

I'm attempting to create a generic Sybase stored procedure which will
accept up to 254 input parameters.  Within the stored procedure
I would like to determine how many parameters were passed to the
stored procedure & process them.  To accomplish this, I'd like to
have a loop which creates input parm names on the fly & retrieve
the values stored in those input parameters. Can this be done?

Here is an example of what I'm trying to do.  The problem here is
clear (see WHILE clause).  The program will evaluate the temporary
variable @argName--not the input parameter @arg1.

    CREATE PROC processArguments
        @arg1    varchar(255),
        @arg2    varchar(255),
        @arg3    varchar(255),
        ...
        @arg254 varchar(255)
    AS
    DECLARE @argName varchar(30)
    DECLARE @argInt  int

    ProcessArguments:
    SELECT @argInt = 1
    SELECT @argName = '@arg1'

    WHILE @argName IS NOT NULL
      BEGIN
        (blah, blah, blah)
        SELECT @argInt = @argInt + 1
        SELECT @argName = '@arg' + (SELECT CONVERT(char(3), @argInt))
      END

Thanks!

Julie Stephens
--
Systems Arch., DHL Airways, Inc., 333 Twin Dolphin Dr, Redwood City, CA 94065
INET: [e-mail]  UUNET: uunet!ssfarch!julies
VOICE: [phone]    FAX: [phone]