Home » SQL & PL/SQL » SQL & PL/SQL » Registering external objects in PL/SQL
Registering external objects in PL/SQL [message #227731] Thu, 29 March 2007 03:50 Go to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,

what is the difference between registering an external procedure in oracle and creating a pl/sql wrapper(as in calling java proc)??? Please clarify.

Reena






Re: Registering external objects in PL/SQL [message #227896 is a reply to message #227731] Fri, 30 March 2007 01:52 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Please help
Reena
Re: Registering external objects in PL/SQL [message #227909 is a reply to message #227896] Fri, 30 March 2007 02:37 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Where did you learn or read about registering external procedures?
Re: Registering external objects in PL/SQL [message #227921 is a reply to message #227731] Fri, 30 March 2007 03:21 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
hi,

i am talking about external routines in pl/sql. to use a DLL/SO for e.g in pl/sql, we need to register it. also, we use wrappers to use java clasess in oracle. i want to know the difference.

thanks
reena
Re: Registering external objects in PL/SQL [message #227923 is a reply to message #227921] Fri, 30 March 2007 03:33 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Check this page.
Then check the documentation on how to build java wrappers.
The two don't look too different..
Re: Registering external objects in PL/SQL [message #227925 is a reply to message #227923] Fri, 30 March 2007 03:38 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

external

stored (wrapper)
Re: Registering external objects in PL/SQL [message #227933 is a reply to message #227731] Fri, 30 March 2007 04:17 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,
Thanks for your reply. I went through the steps for creating them. I want to know if we can use the words registering and creating wrappers interchangeaably? Because both serve the same purpose?

thanks
Reena
Re: Registering external objects in PL/SQL [message #227936 is a reply to message #227731] Fri, 30 March 2007 05:17 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Registration means, tell PLSQL:

1. Where to find the Routine
2. How to call the Routine
3. What to pass to it

Creating a wrapper
Any class that will be directly called from SQL or PL/SQL must be published. A Java class is published by creating and compiling a call specification for it. The call specification, often referred to as a call spec or even a PL/SQL wrapper, maps a Java method's parameters and return type to Oracle SQL types.

I think it's a bit confusing if you would use registering and creating as synonyms.
Re: Registering external objects in PL/SQL [message #227944 is a reply to message #227731] Fri, 30 March 2007 06:01 Go to previous message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
thanks for clarifying
reena
Previous Topic: Setting to single row.
Next Topic: round
Goto Forum:
  


Current Time: Wed Dec 07 16:49:13 CST 2016

Total time taken to generate the page: 0.06275 seconds