DBMS_SQL.COLUMN_VALUE_CHAR Bug

From: Dmitry G. Bezgodov <dima_at_profit.maginfo.net>
Date: Sat, 31 Oct 1998 05:59:19 +0000
Message-ID: <363AA737.E39A46E7_at_profit.maginfo.net>

Hello,
I'm trying to useDBMS_SQL package in form 4.5 of Dev2k v 1.6. Can anyone explain me, why the example does not work:
-- WHEN_BUTTON_PRESSED TRIGGER

• TABLE is abc( id integer, name varchar2(140))

DECLARE c_id number;

id_val number;

name_val varchar2(140);

flag number;

BEGIN c_id:=DBMS_SQL.OPEN_CURSOR;

DBMS_SQL.PARSE(c_id,'select id, name from abc',2);

DBMS_SQL.DEFINE_COLUMN(c_id,1,id_val);

DBMS_SQL.DEFINE_COLUMN(c_id,2,id_name,140);

flag:=DBMS_SQL.EXECUTE(c_id);

flag:=DBMS_SQL.FETCH_ROWS(c_id);

IF flag > 0

THEN   DBMS_SQL.COLUMN_VALUE(c_id,1,id_val); --Works fine, because id_val is integer

  DBMS_SQL.COLUMN_VALUE_CHAR(c_id,2,name_val); --Failed! exception ora-6562!

END IF; DBMS_SQL.CLOSE_CURSOR(c_id);

END;

---

If I use integer(or number) type of column for DBMS_SQL.COLUMN_VALUE, then it works fine,

else if I use varchar2 comumn type, then I get the error ora-06562.

Is it bug?

--

Regards, Dmitry Bezgodov,
Profit Research Group, Russia.
Phones: +7-(3511)-201469,+7-(3511)-200975, Fax: +7-(3511)-213612 http://profit.maginfo.net Received on Sat Oct 31 1998 - 06:59:19 CET