Limitation on size of record in a table

[Former Member]

Hi,

I observe that when I try to insert a record data type "BLOB/XSTRING" with the length of say 60 MB (its a file) fails when the underlying DB is MSSQL. But if the underlying DB is ORACLE, it allows me to insert files up to a length of 80 MB in a single record.

Q1. Are there any standards available (in the form of documentation or otherwise), giving an optimum size for each record when the data type of that attribute is XSTRING/BLOB.

Also let me know the performance hit incase of size when there bytes are retrieved.

With Regards

Murali

[Former Member]

Hi Murali,

You can refer this link for Database Table limitations:

http://www.sapdb.org/7.4/sap_db_features.htm

Regards,

Raj

[Former Member]

hi

1. Ans - Can you call execute a Stored procedure from ABAP

2. Ans - As far as I know, performance should not be a problem because your query is first converted into an optimzed one before it is queried against the DB.

plz reward points if it helps!!

Regards

Gunjan

[former_member113639]

Hi Gunjan,

I would like this to happen independent of the underlying DB. I have not worked as such ABAP, but more a java guy. So I am not sure what is meant by stored procedures. But I would like a general document or something in that direction which lets me know about the optimum size if any.

With Regards

Murali

[Former Member]

hi murli...

stored procedure nothing but a set of sql stat ..which can be run together!!

sorry but dont have any docs on this!!

plz reward points if it helps!!

Regards,

Gunjan