Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Sivaramakrishnan Parameswaran
  Where is Sivaramakrishnan Parameswaran?
 Bangalore
 India
 Sivaramakrishnan Parameswaran
 To: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 Tags
Subject: RE: How to connect to Oracle using OO40
Thread ID: 42782 Message ID: 54998 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, November 4, 2004 4:34:13 AM         
   


samlpe script to extract table info from Oracle using OO40 ORACLE client software. using this one can make use of Oralce PL/SQL power in our applications.

******

oras = CREATEOBJECT("oracleinprocserver.xorasession")
ordb = oras.dbopendatabase ("oraser","userid/passwd",0) && oraser is database alias created using Oracle net easy config
orars = ordb.createdynaset ("select part_stk.part_no , rpad(descr1,50,'.' ), qoh from part_stk , part_mas where NVL(qoh,0) > 0 and (part_stk.part_no = part_mas.part_no) order by part_no" , 0)

recs = orars.recordcount
ctr = 1
DO WHILE ctr <= recs
? SPACE(5),orars.fields(0).value , SPACE(5) , orars.fields(1).value , SPACE(2) , orars.fields(2).value
orars.movenext
ctr = ctr + 1
enddo
orars = .null.
oras = .null.

****

Siva

ENTIRE THREAD

How to connect to Oracle using VFP without ODBC Posted by Thinh Khanh @ 5/11/2004 3:40:48 AM
RE: How to connect to Oracle using VFP without ... Posted by Boudewijn Lutgerink @ 5/11/2004 7:31:37 AM
RE: How to connect to Oracle using VFP without ... Posted by Vu Dinh Hoang @ 11/2/2004 7:39:49 AM
RE: How to connect to Oracle using VFP without ... Posted by Pete Sass @ 11/2/2004 8:05:55 PM
RE: How to connect to Oracle using VFP without ... Posted by Jamie Osborn @ 11/3/2004 11:27:01 PM
RE: How to connect to Oracle using OO40 Posted by Sivaramakrishnan Parameswaran @ 11/4/2004 4:34:13 AM
RE: How to connect to Oracle using VFP without ... Posted by Pete Sass @ 11/4/2004 9:30:59 PM
RE: How to connect to Oracle using VFP without ... Posted by Ken Blum @ 11/5/2004 4:15:41 PM
RE: How to connect to Oracle using VFP without ... Posted by Pete Sass @ 11/6/2004 2:14:43 PM
RE: How to connect to Oracle using VFP without ... Posted by Ken Blum @ 11/8/2004 4:40:49 PM
RE: How to connect to Oracle using VFP without ... Posted by Pete Sass @ 11/9/2004 6:41:17 PM