 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 |
|
|
|
| Re: vb6 and Oracle 8.16 / 11g different results [message #426498 is a reply to message #425930] |
Fri, 16 October 2009 00:37  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I don't know VB6, but - in SQL*Plus (Oracle's command line tool) you might try with SET LONG 2000 and then SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = 'YOUR_VIEW_NAME'.
I suspect that- you should find the way to "emulate" the SET LONG command in VB6, or
- connect to the correct schema (i.e. perhaps you are querying USER_VIEWS that belongs to someone else (who, maybe, doesn't have any views created
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
