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
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
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jan 29, 2010 at 02:37 AM
Seen: 1826 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
additional criteria results in longer processing time
How do I fix a ORA-06502:PL/SQL: numeric or value error on a package
Error in creation of stored procedure---PLS-00103: Encountered the symbol “IF” when expecting one of the following in oracle function
SQL Server-like backups on Oracle?
Select based on value of field
Surrogate key question?
What is the advantage of a view over a normal query?
Factorial function in oracle?
How to recover the file from the Tablespace?