<p>Hi all,</p><p>I have problems with oracle and one cursor using qdesign</p><p>this is the cursor </p><p>SQL IN SGBASE &<br /> DECLARE CSR_CONS_PEND CURSOR FOR &<br /> SELECT &<br /><font color="#0000ff" size="2">(TRUNC</font><font size="2"> </font><font color="#0000ff" size="2">(SYSDATE</font><font size="2"> </font><font color="#0000ff" size="2">-</font><font size="2"> </font><font color="#0000ff" size="2">TO_DATE</font><font size="2"> </font><font color="#0000ff" size="2">(</font><font size="2">fecha_origen</font><font color="#0000ff" size="2">,</font><font size="2"> </font><font color="#ff0000" size="2">'YYYYMMDD'</font><font color="#0000ff" size="2">)))</font><font size="2"> &</font></p><p><font color="#0000ff" size="2">FROM</font><font size="2"> </font><font color="#808000" size="2">CONSULTAS</font><font size="2"> </font><font size="2"><font face="r_ansi" size="2"><p>*E* Error parsing SQL statement.</p><p>DMS-E-GENERAL, A general exception has occurred during operation 'prepare </p><p>request'.</p><p>DMS-E-RBI_COLUMN, Column SYSDATE was not found.</p><p /><p>the problem is in the field sysdate, Anybody Know how solve this problem?</p></font></font></p>
<a href="http://ad.doubleclick.net/clk;106062455;7829128;j?http://match.orange.es/landing/cplanding.aspx?cpp=/ese/lpg/orange/gracias.html&trackingid=1011478" target="_blank">¡Viva los novios! En Match.com lo gritamos todos los días</a>