Re: DBMS_SQL

Thanks Thomas,

I finally got it to work with:

FUNCTION CHECK_FUNCTION

        v_function_name IN VARCHAR2, v_data IN VARCHAR2)
        RETURN VARCHAR2
IS
        v_cursor_id INTEGER;
        v_dummy INTEGER;
        v_temp_string1 VARCHAR2(255);
        v_temp_string2 VARCHAR2(255);
BEGIN
        v_cursor_id := DBMS_SQL.OPEN_CURSOR;
        v_temp_string1 := 'begin :returned_data := PACKAGE_NAME.' ||
v_function_name || '(:input_data_to_function); end;';
        DBMS_SQL.PARSE(v_cursor_id, v_temp_string1, DBMS_SQL.NATIVE);
        DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':returned_data',

        DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':input_data_to_function', v_data,
255);

        v_dummy := DBMS_SQL.EXECUTE(v_cursor_id);
        DBMS_SQL.VARIABLE_VALUE(v_cursor_id, ':returned_data',
v_temp_string2);
        DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
        RETURN v_temp_string2;

Cheers.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jun 01 2000 - 00:00:00 CEST