Forum Stats

  • 3,768,925 Users
  • 2,252,875 Discussions
  • 7,874,802 Comments

Discussions

Oracle Clr Host on adevice that hasen't deployed it

3401304
3401304 Member Posts: 5
edited Feb 22, 2017 9:17AM in .NET Stored Procedures

we know that when we deploy a clr function or procedure a corresponding dll will be added to the path OracleHome/BIN/Clr

and this function or procedure will be added instantly in oracle functions or procedure in extproc

but what about this case when we copy generated clr dll to another device that hosts oracle too to the similar folder

will clr functions or procedures be included in oracle too ,on a device that hasen't deployed this clr dll?

Answers

  • John Stegeman
    John Stegeman Member Posts: 24,269 Blue Diamond
    edited Feb 20, 2017 8:11AM

    - probably a better place.

  • John Thorton
    John Thorton Member Posts: 14,493 Silver Crown
    edited Feb 20, 2017 8:19AM
    23ff420f-5a0c-4230-b346-aff8df7c7485 wrote:we know that when we deploy a clr function or procedure a corresponding dll will be added to the path OracleHome/BIN/Clrand this function or procedure will be added instantly in oracle functions or procedure in extprocbut what about this case when we copy generated clr dll to another device that hosts oracle too to the similar folderwill clr functions or procedures be included in oracle too ,on a device that hasen't deployed this clr dll?

    How do I ask a question on the forums?


  • 3401304
    3401304 Member Posts: 5
    edited Feb 21, 2017 2:27AM

    thanks  because iam a beginner in oracle i forgot to mention that iam working on windows and and the dll which ideployed is .net dll

    is it possible that clr function which has been deployed on a device is going to work on another device that hasn't deployed the dll

  • 3401304
    3401304 Member Posts: 5
    edited Feb 21, 2017 2:48AM

    because it is my first time to write in oracle community apologize me for not good explanation but i wasn't able to edit the question so instead iam replying it

    i want to mention the tutorial which i followed in creating .net procedures or functions

    https://docs.oracle.com/cd/E63277_01/win.121/e63386/demo.htm#CLRNT0004

  • 3401304
    3401304 Member Posts: 5
    edited Feb 22, 2017 9:14AM

    sorry John Stegeman

    but i didn't understand your answer well

    did you mean that i will be able to add and run a clr function on a device that has,'t deployed its dll

    i followed the following steps and they didn't work

    lets's call the device which deployed the clr as A and the other device as B and generated dll mydll and clr function clrfn

    1- i copied  mydll from folder clr on device A to folder clr on device b

    2- i copied clrfn code from device A and run it on device b and that generated clrfn on device b

    3- when i run clrfn on device b i find no ability to run it

    so is what am i doing is right @John Stegeman

  • John Stegeman
    John Stegeman Member Posts: 24,269 Blue Diamond
    edited Feb 22, 2017 9:17AM

    I don't know.

    I simply gave a thought as to the correct forum to post the question. It's now been moved there. I've never written CLR stuff with Oracle.

This discussion has been closed.