JDBC receiver adapter: Insert of CLOB into Oracle DB

[Former Member]

Hi,

I've got a short question:

Is it possible to insert CLOB fields (larger than 4kB) into an Orcale database using the JDBC receiver adapter without using a stored procedure?

We are on XI 3.0 SP20.

I had someting in mind that this is only possible with a stored procedure but I am not sure on this.

Thanks and Regards,

Helmut

[Former Member]

HI,

Is it possible to insert CLOB fields (larger than 4kB) into an Orcale database using the JDBC receiver adapter without using a stored procedure?

yes, you can do it but it is not a best practise, but using Stored Procedure is .

Regards,

karna...

[Former Member]

Hi Karna,

thanks for you reply.

Why wouldn't it be best practise not to use a stored procedure?

Thanks and Regards,

Helmut

[Shabarish_Nair]

Helmut,

i dont see a potential problem updating the DB directly or with a Stored procedure in this case.

PS:

If anybody differs can you state why?

[Former Member]

null

Edited by: hetal shah on Feb 18, 2009 5:22 PM

Edited by: hetal shah on Feb 18, 2009 5:23 PM