All, This is my first attempt to call and oracle stored procedure. Here is my simple procedure: PROCEDURE MTEST ( p_apgt_id IN hdr.apgt_id%type) IS BEGIN insert into test (apgt_id) values (p_apgt_id); commit; END; -- Procedure I have created a 'Z Oracle Stored Procdure' called sqlproc_mtest that refers to my procedure. I also have a small dtml method to test the call: <dtml-var standard_html_header> <dtml-call "REQUEST.set('apgt_id',4444)"> <dtml-call "sqlproc_mtest(p_apgt_id=REQUEST.get('apgt_id'))"> <dtml-var standard_html_footer> When I try to view this, I get the following errors. Am I calling the procedure incorrectly? What is the best way to call an oracle stored procedure? Error Type: DatabaseError Error Value: (6550, "ORA-06550: line 1, column 14:\nPLS-00225: subprogram or cursor 'MTEST' reference is out of scope\nORA-06550: line 1, column 8:\nPL/SQL: Statement ignored") Traceback (innermost last): File /opt/Zope-2.4.0-src/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /opt/Zope-2.4.0-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /opt/Zope-2.4.0-src/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook (Object: LockableItem) File /opt/Zope-2.4.0-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /opt/Zope-2.4.0-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: atest) File /opt/Zope-2.4.0-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: atest) File /opt/Zope-2.4.0-src/lib/python/OFS/DTMLMethod.py, line 194, in __call__ (Object: atest) File /opt/Zope-2.4.0-src/lib/python/DocumentTemplate/DT_String.py, line 544, in __call__ (Object: atest) File /opt/Zope-2.4.0-src/lib/python/DocumentTemplate/DT_Util.py, line 230, in eval (Object: sqlproc_mtest(p_apgt_id=REQUEST.get('apgt_id'))) (Info: REQUEST) File <string>, line 2, in f (Object: guarded_getattr) File /opt/Zope-2.4.0-src/lib/python/Products/ZOracleDA/SP.py, line 150, in __call__ (Object: sqlproc_mtest) File /opt/Zope-2.4.0-src/lib/python/Products/ZOracleDA/DCOracle2/DCOracle2.py, line 1099, in __call__ (Object: MTEST.MTEST) File /opt/Zope-2.4.0-src/lib/python/Products/ZOracleDA/DCOracle2/DCOracle2.py, line 743, in execute DatabaseError: (see above) Thanks. Mike