Weird method 4 ProC error ... please help...

hi...

         i'm writing a proc app that's taking a number of user input variables, building a query to select around them, and then processing the result set... the user can enter or not enter any of several result criterion as he pleases...

        the querystring starts with
SELECT * FROM table WHERE

        and conditional clauses get added depending on what the user inputs... if the user supplies a value for column a, for example, column_a = :a

        is appended to the string...

        when all is said and done, i have an EXEC SQL PREPARE statement process the query string, i declare a cursor, i open it, then i fetch from it... the first time i tried to run it, it gave me an error that there were unbound variables (so i went back and read the manual about method 4)...

        i inserted

EXEC SQL INCLUDE sqlda;

SQLDA *bind_dp;
bind_dp = sqlald (#of items, 20, 20);

EXEC SQL DESCRIBE BIND VARIABLES FOR query INTO bind_dp;

and USING DESCRIPTOR bind_dp; at the end of the cursor open statement...

it all compiled fine, but when i tried to run it, i got the error ORA-3115 unsupported network datatype or representation.

A user bind or define, or an Oracle function, is not supported by this heterogeneous SQL*Net connection.

now, this error message doesn't make sense to me... the :a i'm binding to is a pointer to a character string. i'm logging in locally (though i do have SQL*Net active)... i'm using Oracle Server 7.2.2.3.0 and i have the compatibility variable in the SID.ora file set to 7.2... the action in the error message manual says "upgrade oracle", but something smells wrong here...

can anyone shed light on my darkness? thanks

-mark Received on Mon Nov 25 1996 - 00:00:00 CET