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

Home -> Community -> Usenet -> c.d.o.misc -> pl/sql external procedure call problem

pl/sql external procedure call problem

From: Louis Blanchard <gdsinc_at_govt-data-systems.com>
Date: Mon, 1 Apr 2002 15:16:24 -0600
Message-ID: <3caa1c3c@news3.mylinuxisp.com>


Hello All,

I have an existing C dll with the following parameter/argument calling sequence:

 int SubTrx(int contxt,

             char *strParm,
             long lParmLen,
             char **strResp);  << --problem parameter/argument

I've defined a PL/SQL external function as follows:

  FUNCTION SubTrx

           (
             contxt       in  PLS_INTEGER  default null , -- int
             strParm      in  CHAR         default null , -- char
             lParmLen     in  PLS_INTEGER  default null , -- long
             strResp      out varchar2         -- char ??
           )
  RETURN PLS_INTEGER AS
      EXTERNAL
      LIBRARY ccpro
      NAME "SubTrx"
      LANGUAGE C
      CALLING STANDARD C
      PARAMETERS (
                   contxt       int       ,
                   strParm      string    ,
                   lparmlen     long      ,
                   strResp      by reference string
                 );

How do I dereference strResp in PL/SQL?
What would be the proper external data type for strResp?

Any and all help would be greatly appreciated?

Thanks,

    Louis Received on Mon Apr 01 2002 - 15:16:24 CST

Original text of this message

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