Re: Passing a List to Oracle 8i Stored Proc

[Gary Groomer]

Unfortunately, it is not a simple task to send a list to a stored procedure.  Find attached a copy of one that I developed for use with SQL server.  Hope it helps.  I can't remember if this list strips off attachments.  If it does, I'll send the attachment to you offline.

Gary
  ----- Original Message -----
  From: Dave Carabetta
  To: CF-Talk
  Sent: Wednesday, November 05, 2003 4:43 PM
  Subject: Passing a List to Oracle 8i Stored Proc

  I'm trying to pass a list in to an Oracle 8i stored proc (using MX 6.1), but
  it doesn't seem to be working. This list would be something like:

  BO,AT,CA

  and in the proc, the query would be something like

  SELECT foo
  FROM myTable
  WHERE code IN (theList)

  Is this even possible? If I pass in one value, the proc works fine, but as
  soon as I try and use a list, I get no results back.

  Thanks,
  Dave.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---