Home » Open Source » Programming Interfaces » vb6 and Oracle 8.16 / 11g different results (8.1.6 and 11g and VB6)
icon5.gif  vb6 and Oracle 8.16 / 11g different results [message #425930] Tue, 13 October 2009 03:57 Go to next message
Messages: 13
Registered: March 2009
Junior Member

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


[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 Go to previous message
Messages: 21760
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
Previous Topic: Exact search string match
Next Topic: ODBC config/connection string for Oracle RAC
Goto Forum:

Current Time: Tue Mar 28 00:38:30 CDT 2023