| connecting sap throgh oracle forms [message #233434] |
Thu, 26 April 2007 02:37  |
arvinds_76
Messages: 4
Registered: March 2007
|
Junior Member |
|
|
Hi,
I am using forms 6i . my problem is that i want to create a login screen in forms through which i will pass parameters like
Type:(which is sap )
version
Name of the server
Name of the database
Username
Password
etc..and will be used to connect to SAP
i have one button which will check all these if valid then i should be able to select tables from SAP.
All the tables will be populated from SAP.
Does that require any drivers which need to be installed.
Please guide me in doing so.If any one is having code or fmb it will help me a lot.
Waiting for reply
Thanks in advance
Arvind shinde
India
[Updated on: Thu, 26 April 2007 03:52] Report message to a moderator |
|
|
|
|
|
| Re: connecting sap throgh oracle forms [message #236586 is a reply to message #236438] |
Thu, 10 May 2007 05:29  |
arvinds_76
Messages: 4
Registered: March 2007
|
Junior Member |
|
|
Thanks for reply actually i was waiting for it.
My project is as follows.
Database 8.1.7.0.0
forms 6i
1.I will generate xml file through forms 6i which will be sent to SAP (in xml file i will pass required parameters to connect eg. username,password etc) .
After getting connected SAP will send me xml file which will have data from its table .
for example
if i sent fault of machine from oracle forms in xml file . This file will be stored in disc which will be picked up at certain interval.
SAP will generate xml file regarding how to reslove falut (solution).
Current status of the project is that
i am able to generate xml file and store it via forms 6i.
But problem still there
how to read the xml file ,Store in my 8i database and extract required column to be shown on the form as status and solution for problem.
Is it giving you clear idea about project
please guide me regarding it.
Starting from how to load data in table
(inserting or updating columns data in my database) so that it can be shown through forms to user..
For any clarification you can write to me .As i am awaiting reply.
my email id is arvind_shinde5@rediffmail.com
Thanks and regards,
Arvind shinde.
|
|
|
|
|
|
|
|
| Re: connecting sap throgh oracle forms [message #237302 is a reply to message #237258] |
Mon, 14 May 2007 02:24 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
How about unloading the data into the 10g database and then trying a 'dblink' to the Oracle 8 database and pushing the data down to it? I don't know whether Oracle 10g with talk with Oracle 8 - a quick test will give you the answer. Alternatively, unload the 10g data into a flat file and use SQL*Loader to store it into the Oracle 8 database.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
