CF8 cfprocparam

[mguellouh]

I am working on a project that is running under CF6.1 and oracle 8i, and we're planning to migrate to coldfusion 8 and oracle 10g. my first error in the log files when running the application was Missing dbvarname attribute. so does cf8 support dbvarname or not?
furthermore, what else I should look at during the migration.

Thanks in advance

[Jay-son · Accepted solution]

According to The Adobe LiveDocs, dbvarname is now ignored.

"Changed the dbvarname attribute behavior: it is now ignored for all drivers."

It seems to me that it should ignore it then, instead of erroring. I just tried adding dbvarname to a cfstoredproc on my Oracle 10g server with CF8 and received the error:

"The dbvarname attribute, if used, must be present with each cfprocparam tag of the stored procedure."

So it seems to me, that if you use it, its all or nothing. I don;t use it at all in my cfprocparams and everything works fine, as long as I pass in the Vars in the right order.

[mguellouh]

Thanks for your answer, that really helped