Re: Replicate LONG?

From: Andrew Zhilenko <andrew_at_astral.carrier.kiev.ua>
Date: 1997/04/15
Message-ID: <33536df2@p31.f113.n463.z2.fidonet.org>#1/1

Hello Sidwad!

Long time ago, in one galaxy far, far away..... Monday April 14 1997 10:15, Sidwad wrote to All:

 S> I had faced a similar problem, may be you can do the same

 S> Use Dynamic Sql to split the long raw into chunks, I think You can store
 S> more in Varchar2 variable however don't forget to use HEXTORAW and
 S> RAWTOHEX

I cannot select LONG RAW column in dynamic SQL. (It works fine with LONG). Testing following code:

 stmt := ' SELECT '|| cColName || ' FROM ' || cTabName ||

         ' WHERE rowid = '||''''||cRowid||'''';  cur_id := dbms_sql.open_cursor;
 dbms_sql.parse(cur_id, stmt, dbms_sql.NATIVE);  dbms_sql.define_column_long(cur_id, 1);  ret := dbms_sql.execute(cur_id);

I get an error "ORA-00932: inconsistent datatypes" at line with execute... What's wrong?

Best regards,
Andrew

// Computer Tip #987324: For data compression, take a sledge hammer to your
// hard drive.

• GoldED/386 2.50+
  • Origin: GPF is a registered trademark of Microsoft Corp. (2:463/113.31)

Received on Tue Apr 15 1997 - 00:00:00 CDT