Donkeyhote...
I would love to know the answer to this as well. Have you found the or a solution for this? Can you please give the Metalink document number or name so I can look it up as well? Thanx.
I do not know much about the AQ of Oracle, but an autonomous transaction is when you execute a statement independent of other statements within the same session.
For instance... say you have some PL/SQL code which loads in a bunch of data from an external source. The data is non-normalized and...
I am also new to Oracle Portals, but here's what I know about getting the Portal user password.
Log into the OID Admin program as the orcladmin user. You will need to know this users password to get in. If you don't know where to start the OID Admin program, look in your $ORACLE_HOME/bin for...
haven't tested this, but it seems this will work.
create or replace trigger bu_tblClaim
before update on tblClaim
for each row
declare
invalid_code exception;
tblClient_row tblClient%rowtype;
begin
select * into tblClient_row
from tblClient
where tblClient.Client = :new.Client...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.