Re: Passing tablenamens as parameters to procedures

Forgot to close the cursor:

> declare
> hc integer := dbms_sql.open_cursor;
> rc integer;
> v1 varchar2(20) := 'tablename';
> v2 integer;
> begin
> dbms_sql.parse(hc, 'select count(*) from ' || v1, dbms_sql.v7);
> dbms_sql.define_column(hc, 1, v2);
> rc := dbms_sql.execute(hc);
> dbms_output.put_line(to_char(v2));

     dbms_sql.close_cursor(hc);

> end;

-T- Received on Sat Aug 15 1998 - 22:43:39 CDT