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.
