Need WORKING Example Using Stored Procedures in CFMX7 wOracle9i

[MAT_EDU]

I can't figure out the correct syntax to execute a stored procedure using
ColdFusion 7 Standard Edition with an Oracle 9i database.

It would be very helpful if someone could provide an example (procedure and
CFM) to assist me. At this point, I have tried so many blends of stored
procedure examples on the net that I am totally lost. Many of the examples were
coded incorrectly and I've spent too much time trying to fix the examples
without knowing if the code even works! When I tried executing numerous
examples I found the CF Server hang each and every time and the only fix was to
restart it.

Thank you in advance for your assistance!

[CF_Oracle]

What's the problem? The same syntax as in MX 6.1 and Oracle 8i.
This is example with one input parameter <cfstoredproc
procedure="update_mytable" datasource="#REQUEST.DSN1#">
<cfprocparam type = "IN" CFSQLType = "CF_SQL_VARCHAR"
variable = "p_param1"
value = '#request.key#'>
</cfstoredproc>
Can't send procedure code - clients' property but this is several insert and
update statements started with Create or Replace Procedure as...

[MAT_EDU]

Can you please email me the procedure and CFM code to [email]mat47@cornell.edu[/email]?
I've read here that there are differences between Oracle 8i and 9i. My comment
is toward the bottom.

[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&file=0 0000313.htm
Thank you.

[CF_Oracle]

We don't use reference cursors mentioned in link. Do you really need them?

[MAT_EDU]

Wow.. this large cfproc example.. I am looking for something really easy just
to see if I can get it to work with my setup ... I really don't need to use
reference cursors... I am looking for something that works... anything.. BTW
what is the structure of the "cycle" table?

So far every attempt to run a stored procedure ended up with JRUN.EXE taking
up 100% of a server CPU... It just doesn't terminate...