Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

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; /

Replies are listed 'Best First'.
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?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://888552]
Approved by sundialsvc4
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (7)
As of 2018-03-17 14:24 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (224 votes). Check out past polls.