Home » Developer & Programmer » Forms » how to call VB or .NET dll from Plsql or Forms (merged) (Oracle 9i,Forms 6i)
how to call VB or .NET dll from Plsql or Forms (merged) [message #441728] Tue, 02 February 2010 22:40 Go to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
Hi All ,
Is there any way to call a VB or .NET dll from olsql or forms
thanks in advance
sri
Re: how to call VB or .NET dll from Plsql or Forms [message #441729 is a reply to message #441728] Tue, 02 February 2010 22:46 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can call external procedure from daatabase server (PL/SQL) but it is highly not recommended as it is a hole in security and availability.
The normal is this is the prorgam that calls RDBMS procedures not the opposite. Most if the time when you need this then there is a flaw in the design.
Why do you want to do this?

Regards
Michel
Re: how to call VB or .NET dll from Plsql or Forms [message #441738 is a reply to message #441729] Wed, 03 February 2010 00:01 Go to previous messageGo to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
Hi ,
First of all thanks for your replay ,we had different products devaloped in different plotforms ,now we want to include one product which was devaloped in .net into D2K .For that reason i want to call the dlls of .Net and VB
How to call .Net dll in Oracle [message #441915 is a reply to message #441728] Wed, 03 February 2010 22:37 Go to previous messageGo to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
Hi all,
i want to call a .net dll by useing Oracle is there any way to do it
Re: How to call .Net dll in Oracle [message #441918 is a reply to message #441915] Wed, 03 February 2010 22:46 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Just for reference you can check Create Library this will help you on same line.

Re: How to call .Net dll in Oracle [message #441928 is a reply to message #441915] Wed, 03 February 2010 23:32 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/441728/102589/#msg_441728

Regards
Michel
Re: how to call VB or .NET dll from Plsql or Forms [message #441944 is a reply to message #441738] Thu, 04 February 2010 00:11 Go to previous messageGo to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
so is there any way to call .net dll ?
Re: how to call VB or .NET dll from Plsql or Forms [message #441950 is a reply to message #441944] Thu, 04 February 2010 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about rahulvb's answer?

Regards
Michel
Re: how to call VB or .NET dll from Plsql or Forms [message #442137 is a reply to message #441950] Thu, 04 February 2010 23:04 Go to previous messageGo to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
It is not working for .Net dll
Re: how to call VB or .NET dll from Plsql or Forms [message #442138 is a reply to message #442137] Thu, 04 February 2010 23:06 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not working or you are unable to make it work?
Explain.

Regards
Michel
Re: how to call VB or .NET dll from Plsql or Forms [message #442154 is a reply to message #442138] Fri, 05 February 2010 01:05 Go to previous messageGo to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
Dear Michel ,
I am unable to make it work ,Can you please give me a example

Thanks in advance
sri
Re: how to call VB or .NET dll from Plsql or Forms [message #442163 is a reply to message #442154] Fri, 05 February 2010 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The provided link gives an example to call external procedure.
Did you try to adapt it?
Did you try to search on Google?

When I typed "call .net from plsql" on Google the first hits I got are:
Calling .Net Web Services from Oracle PL/SQL
How to call .Net dll in Oracle 9i

Regards
Michel

Re: how to call VB or .NET dll from Plsql or Forms [message #442166 is a reply to message #442163] Fri, 05 February 2010 01:29 Go to previous messageGo to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
Dear Michel ,
I am very sorry to say this the first one is posted by me only in OTN but i did not get the answer .Plz see my requested thign it is not at all usefull to me
Rgds
Sri
Re: how to call VB or .NET dll from Plsql or Forms [message #442168 is a reply to message #442163] Fri, 05 February 2010 01:30 Go to previous messageGo to next message
sri_rao85
Messages: 25
Registered: September 2006
Junior Member
For your Information since from three days i am working on this in google ,If possible let me know the solution inspite of wasting your valuble time
Re: how to call VB or .NET dll from Plsql or Forms [message #446692 is a reply to message #442168] Wed, 10 March 2010 00:34 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

Have you considered using a Java thingy in your form to make the call to .Net?

David
Previous Topic: To know the printer status
Next Topic: Oracle Forms Resolutions
Goto Forum:
  


Current Time: Tue Sep 27 11:06:16 CDT 2016

Total time taken to generate the page: 0.17297 seconds