Dear Friends,
My oracle Version is 9i.my doubts is trigger related question.Anybod y clear my doubts.Is possible to create DDL OR TCL OR DML inside trigger use execute immediate statements?
Expecting Your replies..
Regards,
Kiss07.
30 3106
Dear Friends,
How can i compile package body?In my requirements lot of local procedures
in package body so i face some problems in package body occur errors in local procedures.
Expecting Your Replies...
Regards,
Kiss07.
Dear friends,
My basic requirements is mention below:
I maintained a table emp it contains all employee details and salary details etc..after one month insert lot of records in day by day order nearly lakhs..
that period execution time is very very low .What can i do improve query performance , please send reply..
Regards,
Kiss07.
Dear ARUN its nice to see u back in the forum after so long.
Dear Friends,
How can i compile package body?In my requirements lot of local procedures
in package body so i face some problems in package body occur errors in local procedures.
Expecting Your Replies...
Regards,
Kiss07.
Post the error messages that you're getting for each procedure.
Try writing the local procedures and function in the package body before calling them. That is the diference in oracle.
Try creating Index on the frequently used columns in the query.
Yes u can go for DML commands.
Can't go for TCL commands.
Can't go for DDL commands.
because DDL commands automatically enforces COMMIT which is not allowed in a trigger.
Some exceptions
=============== =
1.Unlike regular triggers autonomous triggers can contain COMMIT and ROLLBACK.
2.Also these can execute DDL statments,using native dynamic SQL.
Dear Debas,
Thanku Very much..
Regards,
Kiss07
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Xah Lee |
last post by:
Dear functional programing comrades,
Among the community of automatons of the IT industry, there is a
popular quote about "theory vs practice" that goes something along the
lines of "in theory this, but in practice that", which is often quoted
by automatons to slight at computer science principles or
practice. (especially by perl or unix...
|
by: Ornac |
last post by:
I understand that there is much involved in figuring up I/O
throughput, but I'm hoping the answer to the following question will
be a simple A, B OR C.
Given the configuration below, what hardware component would
bottleneck first.
A. Drive Spindle Throughput
B. SCSI Controller
C. Other Component(if so what component?)
|
by: tom mccurdy |
last post by:
Greetings,
There has been a new site created www.quantumninja.com/toe that is to
be used as a resource for people researching the theory of
everything. Please join the community then use what is there, and
offer your own works-- links, papers, reviews, or just to discuss any
questions you may have on The Theory of Everything.
Note: If you...
|
by: designconcepts |
last post by:
bo'jour, bo'jour,
So I have question to present to the forum about OOD. This is a Csharp
forum, but C# is the lang of choice and the question is an exercise based on
some comments by the chief designer of C#. Those of you who are junkies for
design principle might be interested in contributing to this thread.
I was recently reading some...
|
by: Amelyan |
last post by:
I need some help to confirm my theory!
I think I discovered something new for myself about behavior
System.Web.UI.Page.
THEORY: Every time I change control on my WebForm1 page that results in
PostBack, it is handled by a new instance of WebForm1 class, i.e. a new
instance of WebForm1 class is created every time. In general, any GET or...
| |
by: Bob |
last post by:
I know this is a tall order, but I'm looking for a book that talks about the
implications of alternative approaches to languages than we typically see, such
as allowing multiple inheritance... detailed, but not so heavy that the
interesting, qualitative conclusions are left to the reader to dig out of a set
of equations. Any recommendations?
...
|
by: Mayra |
last post by:
hi,
can anyone give me some info on the caracteristics of object relational databases and their advantages as well as disdvantages!
thanx in advance.
|
by: Omar |
last post by:
I've been learning some programming during my little sabbatical (mostly
python), and I thought it'd be cool to see if other people are
interested in programming for music theory. So I started a Music
Theory Programming google group. Consider yourselves invited! It'll
be a place for people with different ideas to make music easier to...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
| |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |