I have 2 procedures. ProceA & procB. ProcA is calling ProcB. Initally I have written them separately. Both are working fine. Now we had a scenario that both has to be on a single procedure.
Can some one tel me how can i club ProcB with ProcA.
Create or replace ProcA
Create or replace ProcB
Is this the correct thing which I am doing or should I need to add any thing else.
in the latest sample : still proca and procb are created as standalone procs
you should add only the body of procb into (somewhere) in proca
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be