Interesting, I tried it just now and it let me make it. It probably failed for me on an older version and I never bothered to try again and just assumed that is how it will be.
Thanks I will play with your example and see if I can make it work in my real world example with multiple fields for insert. As an aside, this method of using cfquery to make a SP, of course only works if the oracle username/password associated with the data source used in the cfquery has permission to create sp's in Oracle. Which is probable not a good thing in a general security sense. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA --------- | 1 | | --------- Binary Soduko | | | --------- "C code. C code run. Run code run. Please!" - Cynthia Dunning ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231835 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
