> -----Original Message-----
> From: Charlie Killian [mailto:[EMAIL PROTECTED]]
> Sent: Freitag, 5. April 2002 04:42
> To: sapdb
> Subject: Error on inserts over 7925 characters
>
>
> I'm getting a general error -9000 when I try to insert text
> into a long
> field if the query and text are over 7925 characters.
>
> What can I do?
>
> Query:
> insert into resumes ( resume ) values ( '
> ... lot's of text here ...
> ')
>
> Table definition:
> create table resumes ( resume long )
>
> Error:
> [SAP AG][LIBSQLOD SO][SAP DB]General error;-9000 POS(1)
> System error: Not
> yet implemented.
>
As Daniel wrote on Nov., 9. 2001:
There shouldn't be a limit if you use java.sql.PreparedStatement and its
setAsciiStream or setString methods. The limits exists only if you try to
insert the LONG value as part of the SQL statement.
And:
The same is true for precompiler-programs, ODBC-application,
which need application-variables which have to be bound to the statement.
It is impossible to specify values of that length in the sql-statement
directly
if they will be used for LONG - columns.
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
