Сейчас использую такой механизм. Он работает в soci::into(z) получаю "кашу"
длиной в 32Kb
Now I use this mechanism. He works in the soci :: into (z) get a "mess" in
length 32Kb
std::string z;
std::string req( "DECLARE \
alert_msg VARCHAR2(1800); \
alert_status INTEGER; \
alert_name VARCHAR2(40); \
BEGIN \
DBMS_OUTPUT.ENABLE; \
DBMS_ALERT.REGISTER('STATUS_CHANGE'); \
DBMS_ALERT.WAITANY(alert_name, alert_msg,
alert_status); \
\
IF alert_status = 1 \
THEN \
DBMS_OUTPUT.PUT_LINE('timed out'); \
\
ELSE \
DBMS_OUTPUT.PUT_LINE('received alert: '||alert_name); \
END IF; \
DBMS_ALERT.REMOVE('STATUS_CHANGE'); \
END;" );
std::cout << req << std::endl;
s << req, soci::into(z);
std::cout << z << std::endl;
Пятница, 12 апреля 2013, 11:29 +04:00 от isoul zi <[email protected]>:
>День добрый!
>
>Кто нибудь пользовался DBMS_ALERT?
>В целом механизм понятен. Не понятно использование WAITANY в связке с SOCI.
>Как получить "alert_message"?
>Если кто то занимался подобной задачей, подскажите как реализовывали.
>Спасибо!
>
>
>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>Good day!
>
>Has anyone used DBMS_ALERT?
>In general, the mechanism is clear. It is not clear WAITANY use in conjunction
>with the SOCI. How to get "alert_message"?
>If someone is doing a similar task , tell me how to implement.
>Thank you!
>
>--
>isoul zi
>------------------------------------------------------------------------------
>Precog is a next-generation analytics platform capable of advanced
>analytics on semi-structured data. The platform includes APIs for building
>apps and a phenomenal toolset for data science. Developers can use
>our toolset for easy data analysis & visualization. Get a free account!
>http://www2.precog.com/precogplatform/slashdotnewsletter
>_______________________________________________
>soci-users mailing list
>[email protected]
>https://lists.sourceforge.net/lists/listinfo/soci-users
>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
