[Zope] DCOracle2 with Oracle 9i Rel2

16 Oct 2003

      Dear all,

Iam using DCOracle2 for Oracle9i Rel2 database.
I create a stored procedure in the database, which is like :

CREATE OR REPLACE PROCEDURE Testproc(
p_username IN VARCHAR,
RESULT OUT VARCHAR
)
AS
BEGIN
  SELECT username INTO RESULT FROM USERS WHERE username = p_username;
END Testproc;

Now, when i create a ZOracle Stored Procedure in Zope for this stored
procedure it always gives an error "Testproc is not a valid stored
procedure".
Can someone pl. help on this. Is it because :

DCOracle2 is mainly meant for OCI8 (oracle8) and hence doesnt work very well
with oracle9, or is it someother problem.

TAI
Satish
ITpreneurs.com