SQL Error - Datatype has changed since first SQLExecute call...
From: <cduncanhudson_at_my-dejanews.com>
Date: Wed, 22 Jul 1998 14:07:13 GMT
Message-ID: <6p4rmh$iad$1_at_nnrp1.dejanews.com>
Hi, I'm hoping someone can help me. I've written a job in a programming language called SQR. The job runs against two tables in an Oracle 7 database and builds a flat file. The program reads the first table and then uses one of the returned fields to select from another table. The combined results are used to create a flat file. The job compiles, and runs for awhile, but then I get the following error:
Date: Wed, 22 Jul 1998 14:07:13 GMT
Message-ID: <6p4rmh$iad$1_at_nnrp1.dejanews.com>
Hi, I'm hoping someone can help me. I've written a job in a programming language called SQR. The job runs against two tables in an Oracle 7 database and builds a flat file. The program reads the first table and then uses one of the returned fields to select from another table. The combined results are used to create a flat file. The job compiles, and runs for awhile, but then I get the following error:
[INTERSOLV][ODBC Oracle driver]Data type for parameter 1 has changed since first SQLExecute call.
I've taken the the actual SQL statement, and the values of the variables that caused the error, and pasted it into SQL Plus - there the query runs fine. Does anyone have any idea what might be causing this error?
C. Duncan Hudson
c_duncan_hudson_at_yahoo.com
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 22 1998 - 16:07:13 CEST