RE: Bug? Problem with Oracle Stored Procedure

2004-02-14 Thread Lincoln Milner
I by no means am an expert in Oracle/CF storedproc calls, but my guess is that Oracle is looking for some kind of input for the IN/OUT parameter, and if you don't pass something in, then it yells. Why do you have an IN/OUT parameter defined if CF is only ever looking to get something out?  My gu

RE: Bug? Problem with Oracle Stored Procedure

2004-02-14 Thread Shawn McKee
Is this just a typo in the e-mail or do I not know the syntax? Shouldn't rocedure be procedure? Shawn McKee -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 5:51 PM To: CF-Talk Subject: Bug? Problem with Oracle Stored Procedure All

Re: Bug? Problem with Oracle Stored Procedure

2004-02-16 Thread Troy Simpson
Typo...  I would have gotten a different error if this was the problem. Troy Shawn McKee wrote: > Is this just a typo in the e-mail or do I not know the syntax? > > > > > > Shouldn't rocedure be procedure? > > > Shawn McKee > > -Original Message- > From: Troy Simpson [mailto:[EMA

Re: Bug? Problem with Oracle Stored Procedure

2004-02-16 Thread Troy Simpson
The variable is defined as IN/OUT because ColdFusion needs to pass in a variable address to recieve the pointer to the query results. qryFoliarHabits is my IN/OUT Generic Cursor Type. Troy Lincoln Milner wrote: > I by no means am an expert in Oracle/CF storedproc calls, but my guess > is th