LiveDocs Comments - coldfusion - 7 - htmldocs - 00000313.htm

coldfusion/7/htmldocs/00000313.htm

Ancient Barking Spider — 2007-02-22T17:51:28

The documentation appears to be wrong and the history missing some information. CFMX 7.0.2 under Cumulative Hotfix 1 now uses attribute dbvarname to allow named parameters. It no longer ignores this attribute; if it is wrong, coldfusion will crash. Perhaps the docs are not routinely updated to reflect hotfixes, but it would be helpful to mention this behavior right here. Thanks!

References:
- ColdFusion MX 7.0.2 Cumulative Hot Fix 1 (cf. note regarding #52712)
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=kb400074

-ColdFusion MX 7.0.2: Using named parameters with stored procedures using cfprocparam
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=24c08da9

--abs

coldfusion/7/htmldocs/00000313.htm

paross1 — 2006-05-11T14:17:05

You still can't use overloaded Oracle procedures if your stored procedure uses ref cursors, as it throws a [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments error. I have seen bug number 53122 associated with this problem back in MX 6.1, but it is still not supported.

coldfusion/7/htmldocs/00000313.htm

2005-09-29T13:12:54

The article http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17938 mentions another way to go through a table (method 2). Is that still working with mx 7? or do we need to switch to cursors?
thanks!

coldfusion/7/htmldocs/00000313.htm

ej345 — 2005-09-11T11:34:46

When "type" is set to INOUT, "variable" attribute is optional and "value" is required in 7,0,0,91690. Documentation has it the other way around.

coldfusion/7/htmldocs/00000313.htm

2005-07-01T05:05:11

You need to build a procedure around it to do a decent call, see http://www.orafusion.com/oracf_pls.htm

coldfusion/7/htmldocs/00000313.htm

jrunrandy — 2005-04-25T12:45:44

My apologies for the continued mistake. Here is a better (if simpler) example.

For the following ORACLE stored procedure:
****************************************
set echo on
-- *** @cMACRSampleRefCursor.sql ***
-- *** NOTE: Logon using the SCOTT schema ***
spool MACR_SAMPLE_PROC.txt
-- ***
-- *** Create script for PACKAGE: MACR_SAMPLE_PROC ***
-- ***
CREATE OR REPLACE PACKAGE MACR_SAMPLE_PROC AS

PROCEDURE sampleproc(
pParam1 in integer,
pParam2 out varchar2);
END MACR_SAMPLE_PROC;

/
CREATE OR REPLACE PACKAGE BODY MACR_SAMPLE_PROC AS
PROCEDURE SampleProc(
pParam1 in integer,
pParam2 out varchar2) IS
BEGIN
IF pParam1 = 1
THEN
pParam2 := 'Hello !!';
ELSE
pParam2 := 'Goodbye !!';
END IF;
END SampleProc;

END MACR_SAMPLE_PROC ;
/
***************************************
You use the following example CFML code:
datasource="psdb_jdbc_ora_817"
RETURNCODE="no">

cfsqltype="CF_SQL_INTEGER"
variable="OneIsHello_TwoIsBye"
value="1">

cfsqltype="CF_SQL_VARCHAR"
variable="HiOrBye">

coldfusion/7/htmldocs/00000313.htm

dougk — 2005-03-08T19:38:29

from above
"You cannot use the cfprocparam tag for Oracle 8 and 9 reference cursors. Instead, use the cfprocresult tag."

yet the example above us using cfprocparam with ref cursors! This same doc mishap is in the 6.1 docs too.