O GUOA foi oficialmente lançado em Angola!
Entre no site para conferir as fotos do Evento e aproveite para se registrar! (www.guoa.org)
...
terça-feira, 12 de novembro de 2013
Como recuperar uma package, function ou procedure dropada acidentalmente
select object_id,object_name,object_type from dba_objects where object_name = 'OWA_UTIL';
select source
from sys.source$
as of timestamp(sysdate - 1)
where obj#=6298
order by lin...
Após o upgrade para 11.2.0.4 - unable to delete any rows from table with context index due to error: "PLS-00306: wrong number or types of arguments in call to 'SYNCRN'" (Doc ID 1586704.1)
After upgrade to 11.2.0.4 unable to delete any rows from table with context index due to error: "PLS-00306: wrong number or types of arguments in call to 'SYNCRN'" (Doc ID 1586704.1)
connect / as sysdba
alter session set current_schema=CTXSYS;
create or replace procedure syncrn (
ownid IN binary_integer,
oname IN varchar2,
idxid IN binary_integer,
ixpid IN binary_integer,
rtabnm IN varchar2,
srcflg IN binary_integer,
smallr IN binary_integer
)
authid definer
as external
...
sexta-feira, 1 de novembro de 2013
Como Instalar o Oracle Developer Suite 6i (Patch 18) em Windows 8
Install Oracle Developer Suite 6i (Patch 18) on Windows 8
http://windows7bugs.wordpress.com/2012/08/25/windows-8-oracle-developer-suite-6i-patch-...
