[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

running a Oracle procedure from a form

Hi,

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>
<tr>
<TD><INPUT TYPE="submit" NAME="submit" VALUE="Calculate" id="buttonEmphasizedRed" nowrap="yes" class="buttonTextEmphasizedRed" TABINDEX="0"></TD>
<INPUT TYPE="hidden" NAME="butCALCULATE" VALUE="butCALCULATE" width=0>
</tr>
</table>
</FORM>

any ideas?
0
joehodge
Asked:
joehodge
1 Solution
 
Renante EnteraCommented:
Hi joehodge!

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

Here are links for your reference :
   <cfstoredproc> - http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pc9.htm#wp2607555
   <cfprocparam> - http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b16.htm#wp1102102

Hope this helps you.  Just try it.


Goodluck!
eNTRANCE2002 :-)
0
 
pinaldaveCommented:
hi,
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 .
Regards,
---Pinal
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now