|
Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.misc ->
Re: Different Query results in Sql *Plus and Oracle ODBC 32Bit Test
Re: Different Query results in Sql *Plus and Oracle ODBC 32Bit Test
- use bind variables. You are killing scalability with what you are doing.
- What version of Oracle?
- Give examples of each (what's the output)
Jim
"Mahua" <mahua_at_saisoft.com> wrote in message
news:694ba138.0203200903.31eefa66_at_posting.google.com...
> Hi
>
> I am new to programming in Oracle and I have a strange problem.
>
> From Vb6 (IIS application) I am connecting to Oracle 8 Using Oracle
> OLE Provider..
>
> Code:
>
> Conn.Open "Provider = OraOLEDB.Oracle;Data Source = Test;User
> ID=abc;Password=xxx;PLSQLRSet=1"
>
> 'Table owner: vcg
>
> Sql = "select a.job_title, b.skill_key, c.skill_value, d.value
> from vcg.t_job_order a, vcg.t_job_order_skill b, vcg.t_skill c,
> vcg.t_employment_type d
> where a.Primary_key = b.job_order_key
> and b.skill_key = c.primary_key
> and a.employment_type_key = d.primary_key
> and a.office_key = 'NMC'
> and a.open_flag = 'Y' and a.active_flag = 'A'"
>
> RecordSet.Open Sql, Conn, adOpenStatic
>
> Problem:
>
> When run this Sql from Sql *Plus (version 8.1.6.0.0) and Oracle ODBC
> 32Bit Test (version 2.5.3.1.0)
> they give different results! The field values as well as the number of
> rows returned are all different.
> When run the above from the Vb, get the same result as the Oracle ODBC
> 32Bit Test.
> Sql *Plus results seem consistent with the query, whereas Oracle ODBC
> 32Bit Test results seem wrong.
>
> Please Help!
> Thanks for any suggestions.
>
> Mahua.
Received on Wed Mar 20 2002 - 20:08:36 CST
Original text of this message
