<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml@01C5EC33.D445AB30">
<link rel=Edit-Time-Data href="cid:editdata.mso@01C5EC33.D445AB30">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:HyphenationZone>21</w:HyphenationZone>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;
        mso-font-charset:0;
        mso-generic-font-family:swiss;
        mso-font-pitch:variable;
        mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {mso-style-parent:"";
        margin:0cm;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;
        text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;
        text-underline:single;}
p
        {mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"Times New Roman";}
span.EstiloDeEmail17
        {mso-style-type:personal;
        mso-style-noshow:yes;
        mso-ansi-font-size:10.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:windowtext;}
span.EstiloDeEmail18
        {mso-style-type:personal;
        mso-style-noshow:yes;
        mso-ansi-font-size:10.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:navy;}
span.EstiloDeEmail19
        {mso-style-type:personal;
        mso-style-noshow:yes;
        mso-ansi-font-size:10.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:navy;}
span.EstiloDeEmail21
        {mso-style-type:personal-reply;
        mso-style-noshow:yes;
        mso-ansi-font-size:10.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:navy;}
span.SpellE
        {mso-style-name:"";
        mso-spl-e:yes;}
span.GramE
        {mso-style-name:"";
        mso-gram-e:yes;}
@page Section1
        {size:612.0pt 792.0pt;
        margin:70.85pt 3.0cm 70.85pt 3.0cm;
        mso-header-margin:35.4pt;
        mso-footer-margin:35.4pt;
        mso-paper-source:0;}
div.Section1
        {page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
        {mso-style-name:"Tabela normal";
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        mso-style-noshow:yes;
        mso-style-parent:"";
        mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
        mso-para-margin:0cm;
        mso-para-margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:10.0pt;
        font-family:"Times New Roman";}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=PT-BR link=blue vlink=purple style='tab-interval:35.4pt'>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mas esse <span class=SpellE>driver</span>
e pago ?? pelo que eu vi no <span class=SpellE>site</span> , a <span
class=SpellE>lincença</span> <span class=SpellE>free</span> e <span
class=SpellE>so</span> por meses.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Não teria como eu acessar o <span
class=SpellE>oracle</span> através de suas <span class=SpellE>APIs</span> <span
class=GramE>( OCI</span> ) alguém já vez isso ??<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Grato<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Márcio<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Mensagem original-----<br>
<b><span style='font-weight:bold'>De:</span></b>
asteriskbrasil-bounces@listas.asteriskbrasil.org
[mailto:asteriskbrasil-bounces@listas.asteriskbrasil.org] <b><span
style='font-weight:bold'>Em nome de </span></b>Frederic Jean<br>
<b><span style='font-weight:bold'>Enviada em:</span></b> sexta-feira, 18 de
novembro de 2005 10:10<br>
<b><span style='font-weight:bold'>Para:</span></b>
asteriskbrasil@listas.asteriskbrasil.org<br>
<b><span style='font-weight:bold'>Assunto:</span></b> Re: [AsteriskBrasil]
Asterisk INTEGRAÇAO com o Oracle</span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Marcio,</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Se o seu banco de dado esta numa
maquina remota,</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>voce teria que instalar os drivers
do Oracle, primeiro, para</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>poder acessar-la.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><a
href="http://www.easysoft.com/products/data_access/odbc_oracle_driver/#platforms">http://www.easysoft.com/products/data_access/odbc_oracle_driver/#platforms</a></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Tambem vc tem que instalar o
unixODBC:</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><a href="http://www.unixodbc.org/">http://www.unixodbc.org/</a></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Quando isto for feito, vc tem a
opcao de usar de um script AGI (perl ou outro)</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>par mandar os queries a partir do
seu extensions.conf. Assim vc pode acessar</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>o seu Oracle sem problema.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Eu ja fiz a experiencia com SQL
Server para armanezar os CDRs e funcionou</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>muito bem; ate a solucao ODBC para
Linux e viavel porque se a conexao</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>for relachada, ele vai ser
reconectada sem intervencao manual. Caso</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>acessar os drivers diretamente, vc
nao vai ter esta funcionalidade.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Boa sorte !</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Frederic Jean</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><a
href="http://www.sunnetgroup.net/br">www.sunnetgroup.net/br</a></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<blockquote style='border:none;border-left:solid black 1.5pt;padding:0cm 0cm 0cm 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>----- Original Message ----- <o:p></o:p></span></font></p>
</div>
<div style='font-color:black'>
<p class=MsoNormal style='margin-left:35.4pt;background:#E4E4E4'><b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-weight:
bold'>From:</span></font></b><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'> <a href="mailto:marciootuca@uol.com.br"
title="marciootuca@uol.com.br">Marcio Oliveira</a> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>To:</span></font></b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> <a
href="mailto:AsteriskBrasil@listas.asteriskbrasil.org"
title="AsteriskBrasil@listas.asteriskbrasil.org">'A Comunidade Brasileira do
PBX OpenSource'</a> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Sent:</span></font></b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> Friday,
November 18, 2005 10:15<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Subject:</span></font></b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>
[AsteriskBrasil] Asterisk INTEGRAÇAO com o Oracle<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;mso-bidi-font-size:10.0pt;
color:navy'>Oi pessoal,<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Gostaria
de saber como <span class=GramE>integrar o banco Oracle no asterisk , estou
precisando</span> em fazer umas consultas na base de dados mas não <o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Tenho q
mínima idéia de como fazer tal coisa ...<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Alguém
poderia me ajudar ...<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Grato <o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Márcio<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
-- <br>
Esta mensagem foi verificada pelo <br>
Email-Seguro-Megaweb CONTRA VÍRUS acredita-se estar livre de perigo <br>
<a href="http://www.emailseguro.megabr.com.br">http://www.emailseguro.megabr.com.br</a>
<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='margin-left:35.4pt;text-align:center'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>_______________________________________________<br>
LIsta de discussões AsteriskBrasil.org<br>
AsteriskBrasil@listas.asteriskbrasil.org<br>
http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil<br>
<br>
_______________________________________________<br>
Acesse o wiki AsteriskBrasil.org:<br>
http://www.asteriskbrasil.org<o:p></o:p></span></font></p>
</blockquote>
</div>
</body>
</html>