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: 1275 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
.Net application invkoing a stored procedure accessing a linked server(Oracle)
Oracle Date Conversion in Openquery
Formatting error in Extrenal tables
How to get the output like this?
Why oracle is using Full table scan even though indexes are defined ?
What is Over Loading and what are its restrictions ?
What is Pragma Init Exception in oracle?
How to port applictions across the platforms ?
How to see the output of the query in page by page ?