asked on

Long data type

I'm reiterrating the same question one more time, since I didn't get the exact answer in a first place...
I've been advised to use clob datatype instead of long and I agree from the technical point, however, in my specific case I need to to generate Long field with at least 8mb for !!!testing purposes!!!

I'm trying to use pl/sql for data manipulation (reading input table and inserting/updating output tables)...
My issue is that there are differences in datatypes between pl/sql "LONG" and an Oracle table column. The PL/SQL can hold up to 32760 bytes while long in oracl table allows to store 2gb.
Please reply with a working solution...

jaramill

So let me understand what you want to do as your questions is vague and you're not asking for something specific. You want to "read" from a database table that has a column of "LONG" type and want to manipulate at least 8MB of data within your PL/SQL code, then insert and update to another database table that has a column of "LONG" type. Is this correct?

Gio

smena

ASKER

Let me try to clarify what my case scenario should be:
1. I need to create a table where one of the column defined as LONG
2. I need to create a test data and insert 8mb data into this column
3. Read this table in PL/SQL, get this columns and try to a) update or b) search for some specific value

I may have the following scenario
input table1
col1-key integer
col2 varchar2
col3 varchar2
col4 long

col4 - should have at least one row with data 8mb

I have to update/insert table2 (output) using table1 that defined as
col1-key integer
col2 long

hopefully it helps.
thnak you

ASKER CERTIFIED SOLUTION

konektor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Vinay_dba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial