Home » Developer & Programmer » Forms » connecting sap throgh oracle forms
connecting sap throgh oracle forms [message #233434] Thu, 26 April 2007 02:37 Go to next message
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 #236438 is a reply to message #233434] Thu, 10 May 2007 00:17 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? Is your SAP in an Oracle database?

David
Re: connecting sap throgh oracle forms [message #236586 is a reply to message #236438] Thu, 10 May 2007 05:29 Go to previous messageGo to next message
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 #236804 is a reply to message #236586] Fri, 11 May 2007 01:14 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please look at http://www.orafaq.com/forum/t/81502/67467/

As I said there:
Do you have any 'dbms_xml' packages in Oracle 8? Why are you working in Oracle 8 (old) and XML (new)? Go to Oracle 10 and you have a world of tools to help you.

David
Re: connecting sap throgh oracle forms [message #237258 is a reply to message #236804] Sun, 13 May 2007 23:31 Go to previous messageGo to next message
arvinds_76
Messages: 4
Registered: March 2007
Junior Member
yes, i do agree on this point but my requirement is to work on 8.1.7 database only. so kindly show me the way.
Thanks
Arvind
Re: connecting sap throgh oracle forms [message #237302 is a reply to message #237258] Mon, 14 May 2007 02:24 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: HL7 Compliant !!!
Next Topic: Req Answers Detail
Goto Forum:
  


Current Time: Sat Dec 03 03:32:34 CST 2016

Total time taken to generate the page: 0.06175 seconds