PUBLIC: Calling PL/SQL stored procedure from C

From: Oliver Muthig <oliver.muthig_at_ubs.com>
Date: Tue, 29 Dec 1998 12:01:52 +0100
Message-ID: <3688B69F.F2755CC9@ubs.com>

Hi,

how could I call the stored procedure from C and process the results? Hostvariables ? Host arrays ? Which C datatypes should I use ?

I read the Oracle Documentation but there are only trivial examples using simple build in datatypes.

CREATE OR REPLACE PACKAGE HS7_PG_AUTOMATIC_SELECTS AS TYPE DATE_ARRAY IS TABLE OF DATE INDEX BY BINARY_INTEGER; TYPE LONG_ARRAY IS TABLE OF LONG INDEX BY BINARY_INTEGER; TYPE NUMBER_ARRAY IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; TYPE VARCHAR2_ARRAY IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
...

FUNCTION SELECT_SYSINFOLIST_ARRAY (
    SESSIONID IN NUMBER,
    ROWS IN OUT BINARY_INTEGER,
    SYSID_ARRAY OUT NUMBER_ARRAY,
    SYSTEM_ARRAY OUT VARCHAR2_ARRAY,
    COMPONENT_ARRAY OUT VARCHAR2_ARRAY,     TIMESTAMP_ARRAY OUT DATE_ARRAY,
    AGE_ARRAY OUT VARCHAR2_ARRAY,
    VALUE_ARRAY OUT VARCHAR2_ARRAY,
    WHERE_CLAUSE IN VARCHAR2 DEFAULT '') RETURN VARCHAR2;
...

Thanks for your help.

Oliver Received on Tue Dec 29 1998 - 05:01:52 CST