OraFAQ Forum: Server Administration » create package + function... (2 Merged)

Home » RDBMS Server » Server Administration » create package + function... (2 Merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create package + function... (2 Merged) [message #521664]

Wed, 31 August 2011 21:53

hanner
Messages: 90
Registered: August 2011
Location: at HOME

Member

Hi,

i know that when you CREATE TABLE, it will result in auto commit.

How about CREATE Package and Function, etc? Do i need to issue

COMMIT; after seeing that it has sucessfully created?

Report message to a moderator

Re: create package + function... [message #521671 is a reply to message #521664]

Wed, 31 August 2011 22:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i know that when you CREATE TABLE, it will result in auto commit.
>How about CREATE Package and Function, etc? Do i need to issue
>COMMIT; after seeing that it has sucessfully created?

You can answer this mystery yourself.
in SESSION #1 CREATE PACKAGE successfully.
start SESSION #2. If #2 can see new PACKAGE then COMMIT was issued by SESSION #1.

So let us know what you learn after you test reality.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: create package + function... (2 Merged) [message #521687 is a reply to message #521664]

Thu, 01 September 2011 01:22

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

For all these kinds of question, please refer to Database Concepts.

For example, here:
Chapter 24 SQL, PL/SQL, and Java
Section Overview of SQL
Subsection Data Definition Language Statements

Regards
Michel

Report message to a moderator

Re: create package + function... (2 Merged) [message #521689 is a reply to message #521687]

Thu, 01 September 2011 01:51

hanner
Messages: 90
Registered: August 2011
Location: at HOME

Member

tks for the help

Report message to a moderator

Previous Topic:	auditing
Next Topic:	Switch between disks in a diskgroup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:26:39 CDT 2024