Help needed on Sybase stored Procedure

Help needed on Sybase stored Procedure

Post by Randy Jord » Thu, 19 Nov 1992 02:56:00



|>Path: pnl-oracle!ogicse!uwm.edu!caen!uunet!csfb1!lhall

|>Newsgroups: comp.databases.sybase
|>Subject: RE: Help needed on Sybase stored Procedure

|>Date: Sat, 14 Nov 92 09:34:19 PST
|>Article-I.D.: csfb1.BxpvH8.IKp

|>Reply-To: uunet!csfb1!lhall
|>Organization: First Boston Corporation
|>Lines: 63
|>
|>Julie Stephans writes :
|>
|>-------- bigin Included TEXT -------
|>

|>Subject: help needed on sybase stored procedure
|>Organization: DHL Worldwide Express, Redwood City, Calif., USA
|>
|>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?
--

        This question made me think...what are you trying to do here.
        This is like asking directions to the store After you walk
        down a dark alley

        State your goal. Someone surely has done it before.
RJ
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        To Thyne Own Self be true...
                                     myne opinions are.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 
 
 

1. help needed on sybase stored procedure

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

        CREATE PROC processArguments



                ...

        AS


        ProcessArguments:



          BEGIN
            (blah, blah, blah)


          END

Thanks!

Julie Stephens
--
Systems Arch., DHL Airways, Inc., 333 Twin Dolphin Dr, Redwood City, CA 94065

VOICE: (415) 802-4694   FAX: (415) 593-1689

2. Error: 7359, OLEDB Provider reported a schema version for table changed between compilation/execution ...

3. Data Dictionary Info Needed

4. sybase stored procedure into informix stored procedure

5. display the status of execution thru progress bar

6. Returning an error code to Sql server Manager

7. Help: Need help creating a GetNextKey Stored Procedure

8. Need Sybase/Sql Server stored procedures/triggers developers:NYC/NJ

9. Need real world code exemples for Stored Procedures with Sybase

10. newbie question - need to connect to Sybase from an NT system(and use stored procedures)