I have a simple stored procedure in Oracle that takes no parms and returns no data.
I can run this proc in sqlplus, works great. Run this from Coldfusion <cfstoredproc name="cleanup" datasource="#dsn#"></cfstoredproc> returns: ORA-06550: line 1, column 18: PLS-00222: no function with name 'CLEANUP' exists in this scope ORA-06550: line 1, column 7: PL/SQL: Statement ignored. Oracle 7 drivers. Only two tables exist in this database. Procedure compiles successfully and runs. Here is the procedure: CREATE OR REPLACE PROCEDURE "CLEANUP" AS BEGIN delete from bdcd where cfid in ( select b.cfid from bdgd b where b.create_date <= trunc(sysdate) ); insert into bdgd select b.cfid, trunc(sysdate + 2) from bdcd b where b.cfid not in ( select a.cfid from bdgd a where a.cfid = b.cfid ); delete from bdgd where create_date <= trunc(sysdate); commit; END; / Any help? Thanks, Greg M ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
