Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

using PL/SQL block with dynamic data

by gdanenb (Acolyte)
on Feb 16, 2011 at 19:23 UTC ( #888552=perlquestion: print w/ replies, xml ) Need Help??
gdanenb has asked for the wisdom of the Perl Monks concerning the following question:

I'm looking for a most efficient way to implement PL/SQL block with dynamic data. For example in the following block there might be different App_profile_Type rows (with various values). Should I prepare $statement with whole block (by concatenating $statement in loop) or there is a better way to do it ?
Declare P_APP_ROW App_profile_Type_tab; v_Return BOOLEAN; BEGIN --- --- Initiate Application profile --- P_APP_ROW := App_profile_Type_tab ( App_profile_Type('JSYSTEM_1007','','',2,'1','0',1,1,1,'0',NULL,NULL,NU +LL), .... .... ); V_Return := APP_PROFILE_LOADER.Load_profile( P_APP_ROW => P_APP_ROW); IF (v_Return) THEN DBMS_OUTPUT.PUT_LINE('v_Return = ' || 'TRUE'); commit; ELSE DBMS_OUTPUT.PUT_LINE('v_Return = ' || 'FALSE'); rollback; END IF; END; /

Comment on using PL/SQL block with dynamic data
Download Code
Re: using PL/SQL block with dynamic data
by sundialsvc4 (Abbot) on Feb 16, 2011 at 21:57 UTC

    It would vastly improve the readability of your posting if you could enclose the Perl stuff in <code> blocks.   Can you please edit your post do that?

      If you would dispense advice about "formatting", surely you would take care when doing so yourself?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://888552]
Approved by sundialsvc4
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (13)
As of 2014-12-29 16:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (193 votes), past polls