Problem inserting data using PL/SQL procedure.

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

more ▼

asked Jan 29, 2010 at 02:37 AM in Default

Parag gravatar image

2 1 1 1

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.
Jan 29, 2010 at 03:56 AM Tom Staab
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

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