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.
For number of rows effected you should be able to get that from the sql%rowcount This is off the top of my head so will need refinement: <cfquery name="test" datasource="something"> create or replace procedure testinsert ( var_myfield IN mytable.mycolumn%type, row_count OUT pls_integer ) as begin insert into mytable (myfield) values (var_myfield); row_count := sql%rowcount; end; / </cfquery> On 2/9/06, Ian Skinner <[EMAIL PROTECTED]> wrote: > > > Actually you can, at least in a limited way. It is a multi-step > process. Somewhere run a query with PL/SQL that creates the SP. Then in > another place run a cfquery or cfstoredprocedure that uses the created sp. > > This is the way I have created and used the very limited SP's I have > experience with. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231833 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
