Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Looking for examples that call C functions from PL/SQL!

Re: Looking for examples that call C functions from PL/SQL!

From: Cho, Hyon-Hyok <cho2h_at_kt.co.kr>
Date: Fri, 23 Jul 1999 10:46:32 +0900
Message-ID: <7n8hi0$tnh$2@news1.kornet.net>


Here is more simple example.

EXEC SQL INCLUDE sqlca.h ;
void main() {

    .....................
     EXEC SQL SELECT FCTR_ID
     INTO :achBandBuf
     FROM TB_BRAABAND
     WHERE CALLING_A_NO =: nCalledANoBuf
     AND  CALLED_A_NO =: nCalledANoBuf
     AND  START_DATE IN
              (SELECT MAX(START_DATE)  FROM TB_BRAABAND) ;

strcpy(pRec->achBand, achBandBuf) ;

.....................

}
>Hello,
>
>Would you please to show me a simple example that from PL/SQL calls
>external C functions ?
>
>Or from Pro C/C++ calls PL/SQL(store procedure) ???
>
>Best regards,
>Eric
>
>--
> _ _
> / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
> / / | | \ \
> _( /_ | _ Chow Hoi Ka, Eric _ | _) )_
>(((\ \> |/ ) ( \| </ /)))
>(\\\\ \_/ / \ \_/ ////)
> \ / E-Mail : eric138_at_yahoo.com \ /
> \ _/ \_ /
> / / |____________________________________________| \ \
> / / \ \
>
>
Received on Thu Jul 22 1999 - 20:46:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US