oracle - How can I insert a long XML string into a blob in pl/sql? -

-

i have xml string has more 5000 characters. have store xml string in oracle db having blob data type shown toad.

how can stored?

try 

insert tabblename values(utl_raw.cast_to_raw(varchar2data));

varchar2 has size 4000 column , 32767 variable.


Comments

Post a Comment

Popular posts from this blog

winapi - How to get a user input on a MessageBox on C++? -

-
i have application on c++ (on windows api) , ask user approve task using messagebox. however, it's bit sensible task , nobody reads message, want change have input box , user type "i agree". does know simple way that? find dialogboxparam() can it, it's overkilling needs, can think on more simple (or simple way use it)? i found prompting user input box? [c++] quite similar question, there no satisfactory answer me (using lib not option). you have write own dialog that. messagebox , related apis not offer such functionality. use task dialog api (introduced in vista) show dialog box button having customised caption. might little better plain messagebox limited set of buttons. i'm little cynical trying achieve in case. if force users type i agree ignore content of dialog box , type ask them type. the difference in outcome between typing dialog , standard button press dialog user take longer past dialog, , dislike software, still not have read ...
Read more

c++ - How call method from Qt GUI in background worker thread using QThread -

-
i'm trying add gui in qt code recieving data vrpn server. , need continuously send data server application , call action(method) in interface when receive information. but have problem endless cycle while (running) . found solution use qthread recieving data server, can't figure out how use method qt class in worker when recieve data server. i tried make worker way, i'm not sure, how call method class when recieve data server (or if it's @ possible/or exist better way): #include "worker.h" #include <iostream> #include "vrpn_analog.h" void vrpn_callback vrpn_analog_callback(void* user_data, vrpn_analogcb analog) { (int = 0; < analog.num_channel; i++) { if (analog.channel[i] > 0) { there want call method nextimage(), have in qt class mainwindow } } } // --- constructor --- worker::worker() { } // --- deconstructor --- worker::~worker() { } // --- process -...
Read more