<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>would it help to say 'FROM <FONT
face="Times New Roman">CONSULTAS<FONT size=2> , DUAL'
?</FONT></FONT></FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=jmalmaga@wanadoo.es
href="mailto:jmalmaga@wanadoo.es ">jmalmaga@wanadoo.es </A></DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, September 07, 2007 2:22
PM</DIV>
<DIV><BR></DIV>
<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></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>
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe:
&quot;subscribe&quot; in message body to
powerh-l-request@lists.sowder.com<BR>Unsubscribe: &quot;unsubscribe
&lt;password&gt;&quot; in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.</BLOCKQUOTE></BODY></HTML>