RE: Problem with Oracle Procedures and OUTPUT parameters

[Olive, Christopher M Mr USACHPPM]

i just went through this whole Charlie Foxtrot of getting CF to play with
Oracle SPs.  i remember reading the Allarie KB, and somewhere it said that
you can't use DBVARNAME with Oracle SPs.  it breaks them.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-----Original Message-----
From: Raftree, Mat [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 12:41 PM
To: '[EMAIL PROTECTED]'
Subject: Problem with Oracle Procedures and OUTPUT parameters


Hello All,

I am having trouble getting Oracle procedures to return OUTPUT
parameters.

I have the following code:

        <cfprocparam type="OUT" 
                        cfsqltype="CF_SQL_VARCHAR"
                        variable=rstype
                        DBVARNAME=resulttype
                        >


This is exactly as the documentation  says to set it up:

It is an output parameter (OUT) of type varchar.

I then hand in my variable from ColdFusion and map it to the parameter
name from the stored procedure (in this case it is: 'resulttype')

I have seen this work when using SQLServer with the DBVARNAME looking
like '@Variable1', but oracle does not use the @ sign with variables.  

Any help would be greatly appreciated.  Please reply to me directly if
you like.

Thanks,

Mathew Raftree
Senior Consultant
Breakaway Solutions, Inc.
50 Rowes Wharf, Boston, MA 02110
617.960.3400 - Office
617.834.0647 - Cell
617.960.3434 - Fax
www.breakaway.com
Get there first. 

"If you look at the history of innovation, you'll see one proven recipe
for breakthroughs: Take a small,  intensely focused team and impose an
unreasonable time frame on it." -- Alan Naumann
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.