Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Passing Parameters ...
Hello *,
who can help me solving this problem:
I need an external procedure (let's call it ZADR) that takes an a priori
unknown number of parameters. Is it possible to implement such a proc? A
call should look like this:
SELECT * FROM xxx WHERE bla = ZADR(a,b,c);
SELECT * FROM xxx WHERE bla = ZADR(a,b,c,d);
Of course this could be done by overloading, but that's not really dynamic. On the C-side I know I can use the vargs-stuff. But on the SQL side ... ?
Thanks in advance
Joerg
PS: Please do also reply via e-mail. I can't watch newsgroups on a regular basis.
--
___ __ \_ \ \ \ Joerg Lanzinger, Tankenrainer Str. 33, 82362 Weilheim _\ \ \ \__ EMail: joerg.lanzinger_at_in.tum.de \___\ \___\ WWW: http://www.in.tum.de/~lanzinge -=* REALITY.SYS maybe corrupt - Reboot universe (Y/N) ? *=-Received on Fri Mar 12 1999 - 08:28:33 CST
![]() |
![]() |