Internal error: Net8 protocol error.

[fusionyogi]

I am getting the following error (similar to the one posted by the original
poster): Error Executing Database Query. [Macromedia][Oracle JDBC
Driver]Internal error: Net8 protocol error Also, I get these two lines after
the query: DATASOURCE datasource_name SQLSTATE 08001 Creating a stored
procedure is an option. However, the code with the SQL query was working fine
earlier and it started giving problem after we upgraded the database to Oracle
9i from Oracle 8. OUR PLATFORM: Windows 2000, ColdFusion MX, Oracle 9i, JDBC
drivers from mid 2002. Does anyone have any idea. This does not seem like a
database problem because the same query works from SQLPlus. Also one
interesting observation was that when I limit the number of rows returned (say
to 15) it works fine! Anyone have any ideas on this issue.

[fabourad]

Hi There, I had the same error but not with Oracle 9i. I had it with Oracle 10.2. I had to update macromedia drivers and that solved the problem.

Hope this helps.

[sdupre]

Go to the latest drivers on
[url]http://www.macromedia.com/go/42dcb10a[/url]

Stephen Dupre
Macromedia QA