satishgaudo.com

Understanding technology

oracle stored procedure

This is an example of writing an stored procedure in oracle:

CREATE OR REPLACE PROCEDURE “INST_SUB_PRIMARY_DET_SAT” (tmp_int in number) IS
 
BEGIN
 
-- cursor
DECLARE CURSOR PRIMARY_DET
IS
SELECT
t.PRIMARY_ID p,
t.SUB_ID s,
t.OFFICE_ADDRESS.OFFICE_NO o1,
t.OFFICE_ADDRESS.OFFICE_NAME o2,
t.OFFICE_ADDRESS.ADDRESS1 o3,
t.OFFICE_ADDRESS.ADDRESS2 o4,
t.OFFICE_ADDRESS.ADDRESS3 o5,
t.OFFICE_ADDRESS.CITY o6,
t.OFFICE_ADDRESS.COUNTY o7,
t.OFFICE_ADDRESS.POST_CODE o8,
t.PRIMACY_NO pri,
t.COMPANY_NAME com,
t.CONTACT_NAME cont,
t.CONTACT_MOBILE mob,
t.CONTACT_PHONE phone,
t.CONTACT_EMAIL email,
t.OFFICE_PHONE opho,
t.OFFICE_FAX ofax,
t.OFFICE_EMAIL oemail,
t.IS_ACTIVE act,
t.IS_DELETE del,
t.ADDDT adt,
t.ADDED_BY aby,
t.ADDED_BY_ID aid,
t.EDITDT edt,
t.UPDATE_BY uby,
t.UPDATE_BY_ID ubi
 
FROM SUBSCRIBER_PRIMARY t;
 
--cres PRIMARY_DET%ROWTYPE;
 
BEGIN
FOR cres IN PRIMARY_DET
LOOP
INSERT INTO SUBSCRIBER_PRIMARY_test2
VALUES(
cres.p,
cres.s,
cres.pri,
cres.com,
cres.cont,
cres.mob,
cres.phone,
cres.email,
office_address_type2(cres.o1, cres.o2, cres.o3, cres.o4, cres.o5, cres.o6, cres.o7, cres.o8, null),
cres.opho,
cres.ofax,
cres.oemail,
cres.act,
cres.del,
cres.adt,
cres.aby,
cres.aid,
cres.edt,
cres.uby,
cres.ubi
);
END LOOP;
END;
 
END;

Now execute the procedure:
execute begin INST_SUB_PRIMARY_DET_SAT(’1′);end;

Bookmark and Share
Categories: Oracle
21 June 2009 at 13:20 - Comments
debt management at 13:15 on 13 November 2009

Nice site protect up your passable work.

watch the social network online at 23:36 on 29 September 2010

Thanks for sharing this link, but unfortunately it seems to be offline… Does anybody have a mirror or another source? Please answer to my post if you do!

I would appreciate if a staff member here at satishgaudo.com could post it.

Thanks,
Harry

Iona Parrent at 09:50 on 4 October 2010

Please visit my site:
najta?sze nowe samochody w polsce
Regards.

Buy Levitra Online at 19:15 on 4 October 2010

Hello, I think this is the coollest blog I`ve seen. I really like your theme.
Buy Levitra Online

Cyrus Yerico at 21:32 on 4 October 2010

I think that not everybody thing something about SEO (in Polish pozycjonowanie witryn)
SEO is like a good marketing agency. It can give You hight position in google rank, so many people will be see your site. I think that you shoud read something more abou SEO in Internet.

Regards.
Grace Horsburgh

Patria Yawn at 08:39 on 5 October 2010

Please visit my site:
kasy fiskalne wagi
Regards.

buy kinect at 18:19 on 16 October 2010

Greetings,

I have a inquiry for the webmaster/admin here at satishgaudo.com.

May I use part of the information from your blog post right above if I give a link back to this website?

Thanks,
Mark

buy kinect at 14:37 on 25 October 2010

Hi,

This is a message for the webmaster/admin here at satishgaudo.com.

May I use part of the information from this blog post right above if I give a link back to this website?

Thanks,
Thomas

watch harry potter and the deathly hallows online at 14:30 on 16 November 2010

Hi,

This is a question for the webmaster/admin here at satishgaudo.com.

Can I use some of the information from your post right above if I provide a backlink back to this site?

Thanks,
Charlie

watch harry potter and the deathly hallows part 1 online at 19:20 on 25 November 2010

Hello,

This is a message for the webmaster/admin here at satishgaudo.com.

May I use part of the information from this blog post right above if I give a backlink back to this website?

Thanks,
James

odessa tx teeth sealants at 01:33 on 29 November 2010

My dad has been writing a book precisely on point with this blog, I have emailed him the web address so perhaps he could pick up a couple pointers. Wonderful Job.

satishgaudo at 14:33 on 30 November 2010

yes

recepti at 00:11 on 6 December 2010

I like the writing structure of your blog and it does a pretty decent job of presenting the info.

virginiabeachroofing at 19:01 on 5 April 2011

This is a very interesting site. The content is very informative and I am so glad that I dropped by. Thanks!
_________________________________
http://www.aquashieldroofingcorpsite.com

CAPTCHA Image
*