I have long column and inserting data using PL/SQL procedure.
The issue is though column long can store 2gb data, pl/sql has constraint of 32K
so i cannot insert data more den 32k. And in reality my data can be more
Jan 29 '10 at 02:37 AM
Jan 29 '10 at 07:11 AM
This is a SQL Server site. PL/SQL is Oracle's SQL language. Did you mean SQL Server's T-SQL, or are you using Oracle? If the latter, I suggest you try posting your question to a different site dedicated to that database system.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Jan 29 '10 at 02:37 AM
Seen: 724 times
Last Updated: Jan 29 '10 at 07:11 AM
How do I write the SQL statement to correctly join I need your help to get these statements in 1 row and multi-Columns
SSRS - Cannot create a connection to Oracle data source Error
Select a Query based on a condition
Alter temporary table throws ORA-14450
Sending mail in oracle?
System Change Numbers (SCN) on 9i, 10g
Can we specify views in a trigger statement ?
What is a forward declaration ? What is its use ?
Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?
DUAL table structure in Oracle ?
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.