C
Chills
Can you help me? I am trying to display a cCLOB field from an Oracle database
in Front Page but the Database Results Property will not verify the query:
select clob from table where dbms_lob.instr(clob, '::Search_Data::',1,1) > 0
There seems to be a problem with the connection string - error reads:
Unable to retrieve schema information from the query
......
against a database using the connection string
DSN=DSNName;DRIVER={Microsoft ODBC for Oracle};UID=username;PWD=password.
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
Unspecified error
If I specifically select other field in the same table, then all is OK -
there is something specifically about the clob field. Does anybody have a
clue?
in Front Page but the Database Results Property will not verify the query:
select clob from table where dbms_lob.instr(clob, '::Search_Data::',1,1) > 0
There seems to be a problem with the connection string - error reads:
Unable to retrieve schema information from the query
......
against a database using the connection string
DSN=DSNName;DRIVER={Microsoft ODBC for Oracle};UID=username;PWD=password.
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
Unspecified error
If I specifically select other field in the same table, then all is OK -
there is something specifically about the clob field. Does anybody have a
clue?