I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored
procedure call. Check your bindings
As a guess, check you are sending the correct number of params and that they
are of the correct type for Oracle.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling
PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can not seem to figure out
the case.
--
Error Executing Database Query.
[Macromedia
.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:07
To: CF-Talk
Subject: Calling Oracle9i StoreProcedure from CFMX
I am calling an Oracle Stored Procedure using CFMX's cfstoredproc tag
and I am getting the following error and I can
param in the SQL is a custom type. Not sure
what to do with this :OS
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:55
To: CF-Talk
Subject: Re: Calling Oracle9i StoreProcedure from CFMX
What would this other CFPROCPARAM look like?
Adrian Lynch
I do not believe this method is support in MX 6.1 as in previous version.
But here is what I tried:
---
cfstoredproc procedure=IAWA_PKG.getIAWAPage
datasource=InsideWood debug=yes returncode=yes
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=A null=no
cfprocparam type=InOut
is a custom type.
Not sure
what to do with this :OS
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2003 18:55
To: CF-Talk
Subject: Re: Calling Oracle9i StoreProcedure from CFMX
What would this other CFPROCPARAM look like?
Adrian Lynch
:[EMAIL PROTECTED]
Sent: 13 October 2003 18:55
To: CF-Talk
Subject: Re: Calling Oracle9i StoreProcedure from CFMX
What would this other CFPROCPARAM look like?
Adrian Lynch wrote:
I don't really know much about Oracle, but from what you have posted
in your
code you seem to have an in/out
8 matches
Mail list logo