DBMS_SQL
From: <jeffremj_at_my-deja.com>
Date: 2000/05/30
Message-ID: <8h10g5$l93$1_at_nnrp1.deja.com>#1/1
END SUBROUTINE1; A long shot, but .....
Date: 2000/05/30
Message-ID: <8h10g5$l93$1_at_nnrp1.deja.com>#1/1
[Quoted] Hi guys and girls,
Can you run functions via DBMS_SQL. I am having problems with this:
FUNCTION SUBROUTINE1
(v_subroutine IN VARCHAR2, v_in 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 := ':returned_data := ' || v_subroutine || '(' ||
v_in || ')';';
DBMS_SQL.PARSE(v_cursor_id, v_temp_string1, DBMS_SQL.NATIVE);
DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':returned_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;
END SUBROUTINE1; A long shot, but .....
TIA.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue May 30 2000 - 00:00:00 CEST