how to pass array in stored procedures

Article View: borland.public.interbase.sql

Article #11084

Back to borland.public.interbase.sql Previous Next

#11084

From: sivaC
Date: Fri, 20 Dec 2002 21:30

22 lines
1393 bytes

Hi,
  In a stored procedure, I have a req. to use OR statements. for example,

CREATE PROCEDURE "REPORT_118"
(
  "pmdate" VARCHAR(10),
  "SO" INTEGER
)

..

in the above procedure, you can pass only one value to SO.  What if I want
to do something like:

  select ... where so = 2 or so = 3 ...

one idea is to pass an array of values and create a procedure to do 'OR'.

any other ideas?

Thanks,
Siva

Technical Details

Message-ID: <3e038c05$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news.stealth.net!news.stealth.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,8a6a27987832b112,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-20 13:39:45 PST
From: "sivaC" <podian@yahoo.com>
Newsgroups: borland.public.interbase.sql
Subject: how to pass array in stored procedures
Date: Fri, 20 Dec 2002 15:30:45 -0600
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
NNTP-Posting-Host: 63.166.115.112
Message-ID: <3e038c05$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040419845 63.166.115.112 (20 Dec 2002 13:30:45 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news.stealth.net!news.stealth.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail