Thanks. The compiled vs interpreted makes sense. I had forgotten that.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 21, 2000 11:35 AM
Subject: RE: Oracle SP and valuelist
> It can be done, and whether it lots of work or not is a matter of opinion.
> The basic issue you're seeing is that Oracle SP's are compiled, whereas CF
> code is interpreted. Anyway, your Oracle coder can either us the DBMS_SQL
> package, which allow creating SQL statements on the fly, or use a
temporary
> table that the list is inserted into and then joined with. If you want
more
> info let me know.
>
> -----Original Message-----
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 21, 2000 1:15 PM
> To: [EMAIL PROTECTED]
> Subject: Oracle SP and valuelist
>
>
> I want to have an oracle sp such that given a string(which is a valuelist)
> v1
>
> does something like:
>
> SELECT * from foo
> where foo_key in (v1)
>
> The oracle db people are claiming this can't be done in plsql without
> writing a lot of code to parse the value list etc. Are they correct? I
can
> certainly do it with cfquery and it seems strange that it would be
difficult
> to handle in a stored proc.
>
>
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
