vb6 and Oracle 8.16 / 11g different results [message #425930] |
Tue, 13 October 2009 03:57 |
larsebaer
Messages: 13 Registered: March 2009
|
Junior Member |
|
|
hello,
i connect with the following code to a Oracle 8.1.6 and a 11g Database.
Dim sSQL As String, rs As New ADODB.Recordset
'cnsrv ist: Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=XXXX;Data Source=XXXX;Extended Properties=""
sSQL = "SELECT view_name, text FROM USER_VIEWS"
rs.Open sSQL, cnSrv, adOpenForwardOnly, adLockReadOnly
When i look into rs!text on the 8.1.6 database i get the complete sql-query for the view(s).
On the 11g database the string ends after 100 Bytes.
There are the same user views in both databases!
Who can help me?
Best regards
Lars
[Updated on: Tue, 13 October 2009 04:34] Report message to a moderator
|
|
|