Calling Pro*C program from a package", version 8.0.5

￡神魔★判官ぃ 2024-02-17 20:32 28阅读 0赞

***You Asked*** (Jump to Tom's latest followup)

Can you provide any information/examples of
    a package that calls a Pro*C program.
    The package must pass several parameters to the Pro*C program.
    It would be even better if the package could pass
    a pointer to a C stucture.
    
    Thanks for your help.
    
    Don Steger

***and we said...***

In Oracle8.0 as you have, we cannot call a Pro*C application.  We have a feature 
    called "external procedures" which allows us to write a stored procedure in C 
    and call it.  This C code may call back into the database using OCI -- but not 
    Pro*C in version 8.0.  
    
    In Oracle8i release 8.1 -- external procedures can be written in Pro*C as well 
    as OCI.  This would statisfy your needs.
    
    You will never be able to pass a "pointer" from a package (PLSQL) to an external 
    procedure as PLSQL does not have the concept of a pointer.  You can, in 
    Oracle8i, pass object types (lots like records), arrays, and scalars to external 
    procedures.
    
    See

[http://download-east.oracle.com/docs/cd/A58617\_01/server.804/a58236/10\_procs.htm\#433731][http_download-east.oracle.com_docs_cd_A58617_01_server.804_a58236_10_procs.htm_433731]

for info on extprocs in 8.0 and

[http://download-east.oracle.com/docs/cd/A81042\_01/DOC/appdev.816/a76939/adg11rtn.htm\#1656][http_download-east.oracle.com_docs_cd_A81042_01_DOC_appdev.816_a76939_adg11rtn.htm_1656]

for info on this feature as it exists in Oracle8i.

<table> 
 <tbody> 
  <tr> 
   <td align="left"><img height="5" alt="" width="5" src="http://asktom.oracle.com/i/FFFFFFTL.gif"></td> 
   <td align="left">&nbsp;&nbsp;<font><strong>Reviews</strong></font></td> 
   <td align="right">&nbsp;&nbsp;&nbsp;</td> 
   <td align="right"><img height="5" alt="" width="5" src="http://asktom.oracle.com/i/FFFFFFTR.gif"></td> 
  </tr> 
  <tr> 
   <td colspan="4"> 
    <table> 
     <tbody> 
      <tr> 
       <td><a style="PADDING-RIGHT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:746425632884#46840437764789" rel="nofollow"><font>GOTO a page to Bookmark Review</font></a> | <a style="PADDING-RIGHT: 6px; PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:15395219516032186935::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:746425632884#PAGEBOTTOM" rel="nofollow"><font>Bottom</font></a> | <a style="PADDING-LEFT: 6px" href="http://asktom.oracle.com/pls/ask/f?p=4950:8:15395219516032186935::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:746425632884#PAGETOP" rel="nofollow"><font>Top</font></a></td> 
      </tr> 
     </tbody> 
    </table> <font><font><img alt="" src="http://asktom.oracle.com/i/stars1.gif"></font><strong>PLease help me!! PRO*C</strong>&nbsp;&nbsp;August 25, 2005 <br>Reviewer:&nbsp; <strong>Duda</strong> &nbsp;from Perú </font><br> <pre>In the question, they ask about call a PRO*C from database oracle. The answer 
didn't satisfied the question. You said: Yes IT can be do it, and put some 
links. I look in the links but nothing say about it. It says only C can be 
called from external procedures, never a pro*c. Please help me and explain step 
to step how can i call a pro*c from a pl/sql???
Thanks a lot 
</pre> <br> 
    <table> 
     <tbody> 
      <tr> 
       <td align="left"><font><strong>Followup:<a rel="nofollow"></a></strong> </font></td> 
      </tr> 
      <tr> 
       <td> <pre>you write an external procedure in C (pro*c is a precompiler....)

If you have access to Expert One on One Oracle -- you have a huge example in 
that book.