[Zope] DCOracle2 with Oracle 9i Rel2
satish.iyer at itpreneurs.com
Thu Oct 16 06:48:02 EDT 2003
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
SELECT username INTO RESULT FROM USERS WHERE username = p_username;
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
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.
More information about the Zope