externa procedures

From: E G <EGlobys_at_yahoo.com>
Date: Wed, 8 Dec 1999 12:03:19 +0200
Message-ID: <82ldvo$q4q$1@trimpas.omnitel.net>

Hi,

I have a problem:
how to declare character string OUT parameter in PL/SQL ?

Declaration like this:
CREATE OR REPLACE

FUNCTION ret_first_file ( dir       IN  VARCHAR2


                        , mask      IN  VARCHAR2


                        , file_name OUT VARCHAR2)

RETURN PLS_INTEGER AS
   LANGUAGE C
   LIBRARY extLib
   NAME "ret_first_file"
   WITH CONTEXT
   PARAMETERS (

        CONTEXT,
        Dir,
        Mask,
        file_name,
        file_name INDICATOR,
        file_name LENGTH,
        RETURN );

declaration of ret_first_file in C is:
long get_first(

     OCIExtProcContext *pOraContext,
     char  *Dir,
     char  *Mask,
     char  *file_name,
     short *file_name_i,
     int   *file_name_l
                            );

Thanx Received on Wed Dec 08 1999 - 04:03:19 CST