Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Zope: DB

Msg of Rinaldo

 

 

Zope db RSS feed   Index | Next | Previous | View Threaded


lisario at libero

Sep 20, 2001, 6:57 AM

Post #1 of 2 (619 views)
Permalink
Msg of Rinaldo

Hi !

I'm using Zope 2.4.0 with Python and DCOracle2

In Python, I've a call at my function in oracle:
newID=c.callproc("FUNZIONE1")

My function in oracle is simply this:
return Integer is
begin
return(-1);
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.
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")

Can I help you?

Thanks,

Rinaldo.


matt at zope

Sep 20, 2001, 7:48 AM

Post #2 of 2 (573 views)
Permalink
Re: Msg of Rinaldo [In reply to]

Rinaldo Lisario wrote:

> Hi !
>
>
>
> I'm using Zope 2.4.0 with Python and DCOracle2
>
>
>
> In Python, I've a call at my function in oracle:
>
> *newID=c.callproc("FUNZIONE1")*
>
>
>
> My function in oracle is simply this:
>
> * return Integer is*
>
> *begin
> return(-1);
> 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. *
>
> *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") *
>
>
>
> Can I help you?
>
>
>
> Thanks,
>
>
>
> Rinaldo.
>
This is a bug with beta 5; functions or procedures that are not in a
package are not called properly. I'm going to try to put out a new
release very soon -- I fixed this a week or two ago but haven't made a
release yet.

Zope db RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.