#70 Update of CLOBs

Next Release
open
nobody
General (16)
5
2009-07-21
2009-07-21
No

I do not know any way to update a CLOB field with a long document using SQLTools. The proposed improvement is to allow to pass CLOB parameters using the &x input parameter syntax. For example, when I execute:
UPDATE document SET content=&1 WHERE doc_id=4775333087182336;
An "Input" dialog appears. But it only has a small single-line text edit control that I can not use to paste my multi-line document. It would be nice if I could tell that this parameter should be passed as CLOB and paste my long document into the multi-line text control.

Discussion

  • Little correction/modification: when you use &x syntax, the input string just textually replaces the &x parameter. So, the bind parameters, :1 syntax, is more appropriate for what I ask for. Currently, when you execute something like UPDATE document SET content=:1 WHERE doc_id=4775333087182336, you will get an the error "ORA-01008: not all variables bound". It would be great if the tool allowed the user to select the type and enter the value of the bind parameters.