Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Troy Simpson
I am calling an Oracle Stored Procedure using CFMX's 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 against the st

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
[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 tag and I am getting the following error and I can not seem to figure out the case. -- Error Executing Database Query. [Mac

Re: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Troy Simpson
e of inout? Just guessing mind. > > > 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'

RE: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Adrian Lynch
] Sent: 13 October 2003 18:55 To: CF-Talk Subject: Re: Calling Oracle9i StoreProcedure from CFMX What would this other 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 th

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: ---     datasource="InsideWood" debug="yes" returncode="yes">              Here is the Error I got back: Error Executing Database Query. [Macromedia][O

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:55 > To: CF-Talk > Subject: Re: Calling Oracle9i StoreProcedure from CFMX > > What would this other look like? > > Adrian Lynch wrote: > > > I do

Re: Calling Oracle9i StoreProcedure from CFMX

2003-10-13 Thread Troy Simpson
n I've noticed the in/out 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