Click here to Skip to main content
14,363,472 members
   

Database

 
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
memberMember 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
protectorJörgen Andersson29-May-19 10:15 
GeneralRe: Debug a procedure in Oracle which feeds into crystal report Pin
Member 1447460731-May-19 6:49
memberMember 1447460731-May-19 6:49 
GeneralRe: Debug a procedure in Oracle which feeds into crystal report Pin
Qingyong Yu16-Jul-19 19:51
memberQingyong Yu16-Jul-19 19:51 
NewsMessage Closed Pin
28-May-19 6:51
memberMember 1447108128-May-19 6: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
membernormga23-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
memberjschell23-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
membernormga23-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
memberjschell2-Jun-19 9:25 
QuestionBest way to batchprocess a large update Pin
Jörgen Andersson23-May-19 3:09
protectorJö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
protectorJörgen Andersson23-May-19 8:52 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson23-May-19 23:08
protectorJö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
protectorJörgen Andersson24-May-19 2:45 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson27-May-19 0:17
protectorJörgen Andersson27-May-19 0:17 
AnswerRe: Best way to batchprocess a large update Pin
Eddy Vluggen24-May-19 1:04
mveEddy Vluggen24-May-19 1:04 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson24-May-19 2:24
protectorJö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 
GeneralRe: Best way to batchprocess a large update Pin
Richard Deeming29-May-19 1:52
mveRichard Deeming29-May-19 1:52 
GeneralRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 2:06
mve#realJSOP29-May-19 2:06 
GeneralRe: Best way to batchprocess a large update Pin
Richard Deeming29-May-19 2:12
mveRichard Deeming29-May-19 2:12 
GeneralRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 2:20
mve#realJSOP29-May-19 2:20 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson29-May-19 3:59
protectorJörgen Andersson29-May-19 3:59 

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.