domingo, 24 de novembro de 2013

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 line


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
  name "comt_cb"
  library dr$lib
  with context
  parameters(
    context,
    ownid  ub4,
    oname  OCISTRING,
    idxid  ub4,
    ixpid  ub4,
    rtabnm OCISTRING,
    srcflg ub1,
    smallr ub1
);
/

sexta-feira, 1 de novembro de 2013

Como Instalar o Oracle Developer Suite 6i (Patch 18) em Windows 8