oracle - PL/SQL complex stored procedure -


i have stored procedure has 1.3k lines of code. stored procedure has several nested calls other procedures in same package.

the total lines of code on package around 13k. there around 25 input parameters (no cursors) , 3 out parameters including 1 cursor.

also, stored proc using few global temporary tables , full of dynamic queries.

every time try debug stored procedure lost. complex piece of code have ever seen , trying understand exact logic of stored procedure. best way approach understand stored procedure?

for ip reason won't able share code on here.

if job change job. ;)

but seriuos there no , quick approach such problem. way can refactor code. split procedure more smaller procedures following naming convention (i know 30 chars few) give better understanding piece of code do.
if have fragments of code duplicated encapsulate them in procedures. if queries long replace dynamically build queries functions generate inside. test such fuctions separately.

generally split code in small chunks , test each chunk unit tests or other way. means many hours of work.


Comments

Post a Comment

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more