[Zope-dev] DCOracle2 and SP problem

Coi Giovanni coi@prometeo.it
Mon, 25 Jun 2001 19:27:51 +0200


The situation:

- Oracle 8.1.7
installed on a machine (excalibur) running SuSE Linux 7.0 (i386) - Kernel 
2.2.16 (2).


- Zope Version: Zope 2.3.3 (binary release, python 1.5.2, win32-x86)
Python Version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)]
System Platform: win32
installed on Windows NT 4.0 SP6a (lancillotto)

- DCOracle2 (DCO2-NT-Beta3.ZIP) also installed on WinNT


The installation standard of DCOracle2 do not run at first try, I moved the 
DCOracle2 directory from ZOracleDA (under 
$ZOPE_HOME/lib/python/Products) to $ZOPE_HOME/bin/lib and it run. 
I can run successfully queries from Z Oracle Databse Connections object's 
Test Page .

But when I create a Z Oracle Stored Procedure object (Procedure name 
GET_ID_UTENTE successfully compiled on Oracle - and successfully 
running with old versione DCOracle1 from another Zope installation - but on 
the Linux (excalibur) machine) the Procedure Description say that:

function GET_ID_UTENTE.GET_ID_UTENTE returns OUT NUMBER, has 
arguments: USERACCOUNT IN VARCHAR2

and the test page return this error message:

Error Type: DatabaseError
Error Value: (6550, "ORA-06550: line 1, column 28:\012PLS-00225: 
subprogram or cursor 'GET_ID_UTENTE' reference is out of scope\012ORA-
06550: line 1, column 7:\012PL/SQL: Statement ignored")

Any ideas?

Thank you in advance.

Giovanni Coi

_________________________________________________________
Prometeo srl - The Software Experience
Coi Giovanni			
Voice : +39 (041)5701366        Via Giudecca 15
Fax   : +39 (041)5701005        30035 MIRANO (VE) - ITALY
e-mail: coi@prometeo.it         http://www.prometeo.it