Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Troy Simpson
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

RE: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Adrian Lynch
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

RE: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Adrian Lynch
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

Re: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Troy Simpson
. 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

RE: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Adrian Lynch
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

Re: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Troy Simpson
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

Re: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Troy Simpson
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

Re: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Troy Simpson
:[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