[Zope-DB] Msg of Rinaldo
Rinaldo Lisario
lisario@libero.it
Thu, 20 Sep 2001 15:57:48 +0200
Messaggio in formato MIME composto da pił parti.
------=_NextPart_000_000B_01C141EC.FE7F08B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi !
I'm using Zope 2.4.0 with Python and DCOracle2
In Python, I've a call at my function in oracle:
newID=3Dc.callproc("FUNZIONE1")
My function in oracle is simply this:
return Integer is
begin
return(-1); =20
end;
But when I try call my python method in zope 2.4.0, there is this =
strange error (in Zope 2.1.0 it was ok):
An exception occurred in a DTML method or document.=20
Error type: DatabaseError
Error value: (6550, "ORA-06550: riga 1, colonna 24:\nPLS-00225: il =
riferimento al sottoprogramma/cursore 'FUNZIONE1' \xe8 esterno a campo =
di validit\xe0\nORA-06550: riga 1, colonna 7:\nPL/SQL: Statement =
ignored")=20
Can I help you?
Thanks,
Rinaldo.
------=_NextPart_000_000B_01C141EC.FE7F08B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm using Zope 2.4.0 with Python and=20
DCOracle2</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>In Python, I've a call at my function =
in=20
oracle:</FONT></DIV>
<DIV><FONT face=3D"Courier New"=20
size=3D2><STRONG>newID=3Dc.callproc("FUNZIONE1")</STRONG></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3DArial></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT face=3DArial>My function in oracle is simply=20
this:</FONT></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2><STRONG> return =
Integer=20
is</STRONG></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2><STRONG>begin<BR> =20
return(-1); <BR>end;</STRONG></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3DArial></FONT></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>But when I try call my python method in =
zope 2.4.0,=20
there is this strange error </FONT><FONT face=3DArial size=3D2>(in Zope =
2.1.0 it was=20
ok):</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2><STRONG>An exception occurred =
in a DTML=20
method or document. </STRONG></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3D"Courier New"><STRONG>Error type:=20
DatabaseError<BR>Error value: (6550, "ORA-06550: riga 1, colonna =
24:\nPLS-00225:=20
il riferimento al sottoprogramma/cursore 'FUNZIONE1' \xe8 esterno a =
campo di=20
validit\xe0\nORA-06550: riga 1, colonna 7:\nPL/SQL: Statement ignored")=20
</STRONG></FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT=20
face=3D"Courier New"><STRONG></STRONG></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT face=3DArial>Can I help =
you?</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3DArial></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT face=3DArial>Thanks,</FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT face=3DArial></FONT></FONT> </DIV>
<DIV><FONT size=3D2><FONT =
face=3DArial>Rinaldo.</FONT></DIV></FONT></BODY></HTML>
------=_NextPart_000_000B_01C141EC.FE7F08B0--