Problem with CFSTOREDPROC

2009-01-11 Thread Mauro Luna
Hi everybody, I have a problem with cfstoredproc and Informix database, when I invoke a stored procedure by cfstoredproc, it returns me several columns with the same name (EXPRESSION) and repeat the value of first column. I am running CFMX 8.0.1 Enterprise, with Informix 9.40 and built

Re: Problem with CFSTOREDPROC

2009-01-11 Thread Mike Chabot
Try to reproduce the problem using only one database column and a three line database query. It is easier to troubleshoot three lines of SQL than 100 lines of SQL. -Mike Chabot On Sun, Jan 11, 2009 at 6:45 PM, Mauro Luna mlane...@cfe.gob.mx wrote: Hi everybody, I have a problem

problem with cfstoredproc - cutom cursor type

2005-09-20 Thread kugh ng
Hi all, I had asked a related Q before and I think I know where the problem is but dont know how to fix it ! I have been getting an error while calling my stored procedure . PLS-00306: wrong number or types of arguments in call to 'GET_METADATA' ORA-06550: line 1, column 7 If I have a user

Having a problem using cfstoredproc

2004-05-07 Thread Brian Yager
Hi all...This is my first time using a stored procedure.I am getting this error [Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored procedure call. Check your bindings against the stored procedure's parameters. Here is my code cfstoredproc