Ask a Question related to Coldfusion Database Access, Design and Development.
-
scurlo9ck #1
Converting CF 5.0 procedure calls to MX
When I try to call my database procedure from within my source code, I receive
the follow error:
[Macromedia][SequeLink JDBC Driver]Output parameters with batch updates are
not supported.
I was only able to find one website that gave a little bit of an explanation:
Cause You cannot use output parameters with batch updates.
Action Check your JDBC application.
I'm not doing any batch update or any updates in my procdure. I am passing
parameters to my procedure and having them return values back to me through my
<CFPROCPARAM> tag. I am connecting to my ORACLE database through an ODBC
socket. Any help would be GREATLY appreciated!!!!!!!!!!!!!
scurlo9ck Guest
-
Converting cfquery to TSQL stored procedure
Does anyone know how to convert this cfquery to TSQL code. The goal is to have MS SQL 2000 run this query in a stored procedure for the sake of... -
DDL calls from SQL PL
Hi, When I try to run/compile the following SQL PL, I get errors for the DDL statements used in them. For example, the GRANT and DROP statements... -
Help, MVS DB2 Remote Stored Procedure calls
I'm having trouble executing a remote SP call. I'm running a mainframe system on z/OS using COBOL LE/370 and DB2 V6 My application is running on... -
Trapping errors from stored procedure calls
We often use code in stored procedures for premature exit, such as SET @returnerror = @@ERROR IF ( @returnerror <> 0 ) BEGIN RAISERROR(... -
Creating a trigger that calls a stored procedure
Hi, Using JAVA (JDBC), I'm trying to create a trigger that calls a stored procedure. However there seems to be something wrong with my syntax... -
paross1 #2
Re: Converting CF 5.0 procedure calls to MX
What ODBC driver are you using, Microsoft's or Oracle's? I would recommend
using the one from Oracle that is appropriate for your version of the database.
[url]http://www.oracle.com/technology/software/tech/windows/odbc/index.html[/url]
Phil
paross1 Guest



Reply With Quote

