how to pass array in stored procedures

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by sivaC Fri, 20 Dec 2002 21:30

#11084

Author: 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

Re: how to pass array in stored procedures

#11085

Author: Craig Stuntz TeamB
Date: Fri, 20 Dec 2002 22:07

17 lines
1659 bytes

In article <3e038c05$1@newsgroups.borland.com>, podian@yahoo.com says...
> one idea is to pass an array of values and create a procedure to do 'OR'.

	Arrays are almost totally unsupported in procs, sorry.
> 
> any other ideas?
> 
	You can put the values in the table and JOIN them into your SELECT.  
This will probably produce a more efficient query anyway.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads