Guido,
Where are getting the data from - other database tables? Because, you could
build a PL/SQL block that contains PL/SQL variables that can hold up to 32k
of data. You could build the string in the variable and insert it into the
LONG column.
Something like:
declare
str_var varchar2(8000
Hi Tom,
thanks for trying to help. Unfortunately I have no chance
because I've no account with write permissions. So it
seems impossible to put the data on the server through ftp.
Oh: and (of course!) no UTL_FILE_DIR defined in the init...ora.
Any other suggestions?
tia,
Guido
>>> [EMAIL PROTEC
Guido...
change the datatype! :-)
Of course, you can't.
Well, have you tried with a Pl-Sql anonymous block?
or...
Oracle says that using BIND variables you can get more
than 4000 chars...
have you tried with bind vars?
HTH
JL
--- Guido Konsolke >
>
> > Hi dear list members,
> >
> > we run
Thanks for the answer, but this no way for me.
Ain't got sqlldr on my client pc and no telnet
to the server 8-((
>>> [EMAIL PROTECTED] 16.07.2003 16.59 Uhr >>>
Try using sql*loader. Put the input data string in a single file as the
input file.
- Original Message -
To: "Multiple recipient