Thanks to everyone for their replies.
If someone is searching for this in the future the solution seems to be as
follows:
If you have a stored proc that DOES NOT require params in or out of the stored
proc, the string to call looks like this
Mixed Case:
cfset storedProcVar = SCHEMANAME.
Been awhile since I had to use Oracle, but is sysdate a function? Can you try:
datetext := to_char(sysdate(), '-mm-dd');
Hi all,
So I'm very stuck and tired of saying mean things to my computer... so
I hope you are able to see something I'm missing.
In short, in order to trouble
This may not be what you're after, but try replacing
datetext := to_char(sysdate, '-mm-dd');
with
SELECT TO_CHAR(sysdate, '-mm-dd') INTO datetext FROM dual;
Thanks,
Eric Cobb
ECAR Technologies, LLC
http://www.ecartech.com
http://www.cfgears.com
Brent Nicholas wrote:
Hi all,
Hi all,
So I'm very stuck and tired of saying mean things to my computer... so I hope
you are able to see something I'm missing.
In short, in order to trouble shoot a larger stored proc call, I've created a
very simple one to get working first. It just returns a value.
Platforms: Oracle11g /
returncode=yes
What's with the param 1 in front of the call? then another
param 2??
A complete guess from a non-Oracle person, but ... could it be for the return
code?
~|
Order the Adobe Coldfusion Anthology now!
returncode=yes
What's with the param 1 in front of the call? then another
param 2??
A complete guess from a non-Oracle person, but ... could it be for the return
code?
Ok, I've removed returncode and debug and now have the following.
cfstoredproc procedure=#storedProc#
I had incorrect information in my error in the previous two posts.
It should read:
The error: (nemisis)
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00900: invalid SQL statement
The error occurred in D:\somepath\act_updateProgramFund.cfm: line 50
48 :
49 : cfstoredproc
7 matches
Mail list logo