Oracle, the variable invariably takes on a value of 1 instead of
whatever was determined in the stored procedure.
For example, here is where the stored procedure is called:
<cfstoredproc datasource="mydata" procedure="myproc" debug="yes">
<cfprocparam type="in" dbvarname="myVar" value="12"
cfsqltype="cf_sql_integer">
<cfprocparam type="out" dbvarname="myVar2" variable="myResult"
cfsqltype="cf_sql_integer">
</cfstoredproc>
...and here is the stored procedure:
CREATE OR REPLACE procedure myproc (
myVar int,
myVar2 out
) as begin
myVar2 := 0;
myVar2 := myVar * 2;
end myproc;
/
Now, when I do something like:
<cfoutput>#myResult#</cfoutput>
I should see "24" displayed on the screen. Instead I see "1". Why is this?
--
Richard S. Crawford
Programmer/Analyst III,
UC Davis Extension Distance Learning Group
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
