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
I don't really know much about Oracle, but from what you have posted in your
code you seem to have an in/out param in the SP, if that's the case wouldn't
you need another cfprocparam with type of inout? Just guessing mind.
Ade
-Original Message-
From: Troy Simpson [mailto:[EMAIL
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 param in the SP, if that's the case
wouldn't
you need another cfprocparam with type of inout? Just guessing mind.
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
7 matches
Mail list logo
