Oracle PL/SQL > Stored Procedure Hanging Indefinitely -



Oracle PL/SQL > Stored Procedure Hanging Indefinitely -

i'm in business side of house , not have total dba privileges our oracle 11g database. have privileges necessary build , run stored procedures , have 1 hanging indefinitely.

we're developing new scheme , have several life-cycles. code works 100% fine in before lifecycle (call ad) , hangs indefinitely in next lifecyle (qa). stops @ first major sql pull , never returns.

when run exact sql that's within stored procedure outside straight sql pull, comes in 2.6 seconds (using same input parameters , same qa lifecyle server).

i have limited ability see what's going on within stored procedure it's running because of privileges , dbas don't have insight pl/sql code help debug or troubleshoot.

so, open-ended question is: going wrong?? know vague. things have checked:

the database has info in tables i'm pulling from i've checked of input parameters , beingness passed procedure function, etc. correctly i've run same code outside of procedure , returns , displays right data. the exact code works in lower lifecycle (literally copy/pasted advertisement qa). the dba says server environment same (i'm not sure believe him, have no direct means verify).

any help can provide golden. post code, 2-3k in length, i'm not sure that's helpful. give code works fine , copy/pasted as-is, don't think it's coding problem, system/environmental problem.

any ideas helpful.

thanks in advance!

looks issue unrelated stored procedure. comments. :)

oracle stored-procedures plsql oracle11g stored-functions

Comments

Post a Comment

Popular posts from this blog

javascript - I need to update the text of a paragraph by inline edit -

javascript - I need to update the text of a paragraph by inline edit - i've tried this html <div> <h1>some text here</h1> <p>text area text here</p> </div> jquery $(function(){ $('p').on('click', function(e){ e.preventdefault(); var txt = $(this).text(); $(this).parent().append('<textarea>' + txt + '</textarea>'); $(this).remove(); }); }); i need update text of paragraph inline editing. need paragraph new text typed there , remove textarea when click outside of textarea. thanks here update fiddle http://jsfiddle.net/99pxz8et/2/ what need hear on alter event new text area , update it $area.one('focusout', function() { $p.show(); $p.text($area.val()); $area.remove() }); edit: changed .on() .one() javascript jquery
Read more

javascript - THREE.js reposition vertices for RingGeometry -

javascript - THREE.js reposition vertices for RingGeometry - codepen available here: http://codepen.io/pehrlich/pen/cogjg i want render ring geometry in scene, , dynamically alter it's arclength (thetalength). start with, i'm calling it's constructor, , recalling code positions vertices. however, causes unusual results. here's method phone call - copied constructor , given new name of setthetalength: three.ringgeometry.prototype.setthetalength = function(thetalength){ // this.thetalength = thetalength; var i, o, uvs = [], radius = this.innerradius, radiusstep = ( ( this.outerradius - this.innerradius ) / this.phisegments ); ( = 0; < this.phisegments + 1; ++ ) { // concentric circles within ring ( o = 0; o < this.thetasegments + 1; o ++ ) { // number of segments per circle var vertex = this.vertices[i + o]; // maybe need query vertex indices here. var segment = this.thetastart + o / this.thetasegments *...
Read more

assembly - What is the addressing mode for ld, add, and rjmp instructions? -

assembly - What is the addressing mode for ld, add, and rjmp instructions? - hey guys know ldi (load immediate) addressing mode set immediate , st instruction addressing mode set index. however, have no thought others curious are! thanks :) the addressing modes explained in instruction set, in first few pages. in table of instructions see operands instruction determine addressing mode. mode indicated arguments assembly instruction. for example, ld had several different ways of operating, depending on arguments. 1 of them ld rd,x d number of register, such ld r3,x . ld r3,-z else (although both indirect addressing). rjmp k relative addressing, jumping pc + k + 1. add rr,rd direct register addressing. result contained in rd. assembly avr instructions
Read more