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.
