Re: Different Query results in Sql *Plus and Oracle ODBC 32Bit Test

1. I am simply using a test sql for testing purpose...the final query will have variables.
2. Oracle version :8.0.3.0.0 for windows NT. Sql *Plus(version 8.1.6.0.0) .Oracle ODBC 32Bit Test (version 2.5.3.1.0)
3. I tried with a simple query without any where conditions and joins: "Select value from vcg.T_EMPLOYMENT_TYPE" and it gave 4 rows in ODBC 32Bit Test and 5 rows in Sql *Plus. Results: ODBC Test Sql *Plus 1.Contract Hourly 1.ContractHourly 2.Perm 2.Perm 3.Contract Salary 3.Contract Salary
4. Reference Contact 4.Contract 5.Reference Contact

Thanks
Mahua.

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<Egbm8.80297$ZR2.35868_at_rwcrnsc52.ops.asp.att.net>...
> 1. use bind variables. You are killing scalability with what you are doing.
>
> 2. What version of Oracle?
> 3. 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 Thu Mar 21 2002 - 09:31:03 CST