Re: YES! YES! YES! ;-)

Afternoon Martin,

On 26/09/12 17:55, Martin Gainty wrote:
> Norm
>
> apparently direct writes to any LOB are verboten.. one should always
> invoke DBMS_LOB.WRITE(clob,length(varchar_input),1,varchar_input)
That's news to me, but I don't work with them as much as I should. This 
one is XML stored in a CLOB and every single row in the table has a 
binary zero character at the end of the XML data.

Problem is, only 25% of the data are being flagged up as invalid XML by 
the application, so I suspect that the application may be written in C 
or C++ and the binary zero is an "end of string" byte. I don't think it 
should be in the data.

Saving to a file saves the binary zero and stops the data loading in a 
browser. Firefox helpfully says "invalid character at line x column n, 
IE says "the file is invalid" - not helpful!


> http://geekswithblogs.net/robertphyatt/archive/2010/03/24/write-read-and-update-oracle-clobs-with-plsql.aspx
If you read down the comments, the second one updates the original code 
for "later versions of Oracle" and does this as an update:

UPDATE TBL_CLOBHOLDERDDOC
SET CLOBHOLDERDDOC = p_document
WHERE CLOBHOLDERDDOCID = p_id;

So, Toad is fine - I'm doing all this on 11203.


> since youve mastered SSH i take it you are now a Eunuchs guy?
I'm not sure anyone has mastered SSH, but I did write an Ask Toad 
article, years ago, about using ssh tunnelling to get to a database from 
a problem location. I've been foxed by a firewall between me and the 
database, so I couldn't even use ssh tunnelling.

However, after a few eRants about this, I've been given the ability to 
ssh tunnel onto my databases. Or, at least, some of them.

Toad 11.5 upgrade installed this Am and working perfectly. I am a happy 
Norm again.


-- 
Cheers,
Norm. [TeamT]


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/