Dynamic pl/sql

I have a need to run remote pl/sql procedures from within a pro-c program. The procedure will always have the same name, however, the datatype of the input/output parameters will change and the procedure name will be overloaded within the package to accomodate the different combinations of parameters.

Since the types of parameters that will be needed are not known until run-time I need to be able to construct the calling pl/sql routine dynamically. In a vague sort of way this is basically what I want:

int myfunc (parameters)
{

    char plsql[500];

    plsql = <logic to build a string containing a plsql block>

    exec sql execute
    plsql;
    end-exec;
}

Has anyone done this type of thing? Any code examples? Received on Tue Aug 31 1999 - 07:46:55 CDT