| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: About PRAGMA...
A copy of this was sent to kexutaja_at_my-dejanews.com
(if that email address didn't require changing)
On Thu, 01 Apr 1999 06:09:19 GMT, you wrote:
>Hi.
>
>I'm using here some dll's in my forms and they are working just fine. But I
>have some questions. I couldn't find any information about PRAGMA INTERFACE
>parameters. So i just copied it from help and used like : PRAGMA
>INTERFACE(C,my_function_name,11265); And of course it works. But can anyone
>point me direction or just explain what these 'C' and '11265' mean there? I
>actually don't like to copy from help, i'd like to understand :)
>
it didn't really work -- it compiled but it won't run. You'll get an error "missing ICD vector" if you try to run it.
The pragma interface is an internal interface. It can only be invoked by SYS run code (your package has to be owned by SYS for it to work -- it you take some code like UTL_FILE and compile it under system for example, you'll get the missing icd vector error since its not SYS).
Not only that but it can only be used to interface to a set of well defined, known and exported kernel functions. It cannot be used by sys to interface to some non-oracle kernel function. In short -- you and I cannot use it for anything. Its only useful as a mechanism for the kernel developers to expose some kernel functionality via plsql.
If you have Oracle8, the feature you are looking for is called an external procedure. That allows you to implement your plsql procedures/functions/triggers/etc in C in a documented, supported fashion.
>Thankful
>
>LK
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |