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
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 '10 at 02:37 AM
Seen: 1273 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
How can you see the source code of the package ?
Find the jobs list in Oracle
Data corrupting on insert to Oracle table through a view
slowly shanging dimension to oracle not working
About No Logging option in Oracle?
How to get last number of all sequences?
How can I change sql prompt name?
How can we view the PL/SQL errors?