Re: dbms_sql question

From: Roman Rahimov <roman_at_santel.ru>
Date: Mon, 29 Jan 2001 11:37:29 +0300
Message-ID: <953a8t$12p9$1@serv2.vsi.ru>

Hello!

> My question is: (how) can I identify the columns that are being selected?

via dbms_sql.define_column

here is my example
.........
  source_cursor INTEGER;
  vValue VARCHAR2(2000):='';
  row_processed INTEGER;
BEGIN
  source_cursor:= dbms_sql.open_cursor;

  dbms_sql.parse(source_cursor,'select object_name from t1 where
object_no=:vObjectID',1);
  dbms_sql.bind_variable(source_cursor,':vObjectID',pObjectID);
  dbms_sql.define_column(source_cursor, 1, vValue,2000);

  row_processed:=dbms_sql.execute(source_cursor);   IF dbms_sql.fetch_rows(source_cursor)>0

      THEN dbms_sql.column_value(source_cursor, 1, vValue);   END IF;
  dbms_sql.close_cursor(source_cursor);
.........

Good luck! Received on Mon Jan 29 2001 - 02:37:29 CST