To be sure that it's the fact you have no params that's giving you the error, change the SP so it takes one param, you don't have to do anything with it, then pass a valid one in and see if it still falls over.
This might give you some insite into whether it's the lack of params that's the problem. Ade -----Original Message----- From: Greg McDaniel To: CF-Talk Sent: 6/13/03 10:50 PM Subject: How to call CFSTOREDPROC without parms 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
