running a Oracle procedure from a form

Posted on 2005-05-11
Last Modified: 2013-12-24

I am migrating my plsql generated pages to coldfusion and would like to know how I run an Oracle procedure from a form e.g.

<FORM ACTION="Pkg_EVE_Process.Pr_ProcessSAP" METHOD="POST" onsubmit="disablesome()" name="frm4">
<table cellpadding=1 cellspacing=1 align=center>
<TD><INPUT TYPE="submit" NAME="submit" VALUE="Calculate" id="buttonEmphasizedRed" nowrap="yes" class="buttonTextEmphasizedRed" TABINDEX="0"></TD>

any ideas?
Question by:joehodge
    LVL 14

    Accepted Solution

    Hi joehodge!

    When speaking of running stored procedures, you need to use "<cfstoredproc>" and "<cfprocparam>".

    Here are links for your reference :
       <cfstoredproc> -
       <cfprocparam> -

    Hope this helps you.  Just try it.

    eNTRANCE2002 :-)
    LVL 22

    Expert Comment

    In when you use stored procedure pass the variable in the order to the stored procedure because there is bug in the CF MX still that it does not take them out of order even though you specify dbvarname .

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
    Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video discusses moving either the default database or any database to a new volume.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now