Skip to main content
M
mguellouh
Participant
April 17, 2008
Answered

CF8 cfprocparam

  • April 17, 2008
  • 2 replies
  • 740 views
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
    This topic has been closed for replies.
    Correct answer Jay-son
    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.

    2 replies

    M
    mguellouhAuthor
    Participant
    May 26, 2008
    Thanks for your answer, that really helped
    J
    Jay-sonCorrect answer
    Participating Frequently
    April 17, 2008
    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices