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, 2010 at 02:37 AM
Jan 29, 2010 at 07:11 AM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jan 29, 2010 at 02:37 AM
Seen: 1574 times
Last Updated: Jan 29, 2010 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
Is SSRS is portable to other Database like Oracle
OPENQUERY Error when accessing Oracle
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 ?
Can one use dynamic SQL within PL/SQL?
What is hash cluster? When can hash cluster used ?
Date Calculations - First of Month, Last of Month, More