Click here to Skip to main content
15,789,776 members
Home / Discussions / Database
   

Database

 
AnswerRe: MongoDB via WebAPI Question Pin
Nathan Minier31-May-19 8:22
professionalNathan Minier31-May-19 8:22 
GeneralRe: MongoDB via WebAPI Question Pin
Kevin Marois31-May-19 8:25
professionalKevin Marois31-May-19 8:25 
GeneralRe: MongoDB via WebAPI Question Pin
Nathan Minier31-May-19 9:03
professionalNathan Minier31-May-19 9:03 
GeneralRe: MongoDB via WebAPI Question Pin
Kevin Marois31-May-19 9:38
professionalKevin Marois31-May-19 9:38 
GeneralRe: MongoDB via WebAPI Question Pin
Nathan Minier31-May-19 9:51
professionalNathan Minier31-May-19 9:51 
AnswerRe: MongoDB via WebAPI Question Pin
#realJSOP10-Jun-19 6:19
mve#realJSOP10-Jun-19 6:19 
GeneralRe: MongoDB via WebAPI Question Pin
Kevin Marois10-Jun-19 6:23
professionalKevin Marois10-Jun-19 6:23 
QuestionDebug a procedure in Oracle which feeds into crystal report Pin
Member 1447460729-May-19 6:13
Member 1447460729-May-19 6:13 
Hi,
I have debugged a stored proc in Sql Server, which was fairly easy to do.

I am trying the same with debugging Oracle procedures, being fairly new having some difficulties. I have researched how to output a cursor value, with no luck.

Also, the sql is constructed, and then used in cursor to output results to crystal report.

My final sql looks like this, which is a whole bunch of variables:
ssql := s_SEL||s_FROM1||s_WHERE||s_WH_PER||s_WH_CC||s_WH_VEN
||s_UNION||
           s_SEL||s_FROM2||s_WHERE||s_WH_PER||s_WH_CC||s_WH_VEN


I tried with no luck:

execute immediate ssql


I just want to see the values of the sql statement.

Any help is much appreciated!
AnswerRe: Debug a procedure in Oracle which feeds into crystal report Pin
Jörgen Andersson29-May-19 10:15
professionalJörgen Andersson29-May-19 10:15 
GeneralRe: Debug a procedure in Oracle which feeds into crystal report Pin
Member 1447460731-May-19 6:49
Member 1447460731-May-19 6:49 
GeneralRe: Debug a procedure in Oracle which feeds into crystal report Pin
Qingyong Yu16-Jul-19 19:51
Qingyong Yu16-Jul-19 19:51 
QuestionCentOS6.9 (MySql v5.7.22) use mysql C API mysql_real_query cause the memory always growing Pin
normga23-May-19 4:13
normga23-May-19 4:13 
AnswerRe: CentOS6.9 (MySql v5.7.22) use mysql C API mysql_real_query cause the memory always growing Pin
jschell23-May-19 7:41
jschell23-May-19 7:41 
GeneralRe: CentOS6.9 (MySql v5.7.22) use mysql C API mysql_real_query cause the memory always growing Pin
normga23-May-19 10:27
normga23-May-19 10:27 
GeneralRe: CentOS6.9 (MySql v5.7.22) use mysql C API mysql_real_query cause the memory always growing Pin
jschell2-Jun-19 9:25
jschell2-Jun-19 9:25 
QuestionBest way to batchprocess a large update Pin
Jörgen Andersson23-May-19 3:09
professionalJörgen Andersson23-May-19 3:09 
AnswerRe: Best way to batchprocess a large update Pin
Richard Deeming23-May-19 8:38
mveRichard Deeming23-May-19 8:38 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson23-May-19 8:52
professionalJörgen Andersson23-May-19 8:52 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson23-May-19 23:08
professionalJörgen Andersson23-May-19 23:08 
GeneralRe: Best way to batchprocess a large update Pin
Richard Deeming24-May-19 1:44
mveRichard Deeming24-May-19 1:44 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson24-May-19 2:45
professionalJörgen Andersson24-May-19 2:45 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson27-May-19 0:17
professionalJörgen Andersson27-May-19 0:17 
AnswerRe: Best way to batchprocess a large update Pin
Eddy Vluggen24-May-19 1:04
professionalEddy Vluggen24-May-19 1:04 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson24-May-19 2:24
professionalJörgen Andersson24-May-19 2:24 
AnswerRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 1:43
mve#realJSOP29-May-19 1:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.