DBMS_SQL.DEFINE_COLUMN problem [message #37325] |
Thu, 31 January 2002 00:00 |
Anthony
Messages: 48 Registered: September 2000
|
Member |
|
|
Hi all message previously posted in sql but is more pertinent on this board.
I am using a dynamic pl/sql procedure and I am having trouble trying to return a value from the database into a local variable, I am using the define_column procedure from DBMS_SQL, there is no value returned to populate the final table
v_count integer(6);
begin
v_STR_SQL := 'select count(*) XXX from emp';
i_CURSOR := DBMS_SQL.open_cursor;
DBMS_SQL.parse(i_CURSOR, v_STR_SQL, DBMS_SQL.v7);
DBMS_SQL.define_column(i_CURSOR,1,v_count);
i_ROWS_PROCESSED := DBMS_SQL.execute(i_CURSOR);
DBMS_SQL.close_cursor(i_CURSOR);
insert into ants values ('v_count is',v_count);
t.i.a for any advice
regards
|
|
|
|
|