Hello, I'm trying to use CFSTOREDPROC with Oracle in an attempt to speed up my queries (instead of using CFQUERY)
Can anyone give me a very quick guide on writing the stored proc to talk to CF? I have one input parameter - a name, and one output parameter - a recordset. Have not written stored procedures before so unsure on the syntax. Basically, using the EMP and DEPT tables supplied with oracle I want to select all employees/departments whose name starts with the letter the user inputs. my query is: select e.empno, e.ename, e.deptno, d.dname from emp e, dept d where e.deptno = d.deptno and e.ename like 'S%' (the 'S%' is obviously what I want as my input parameter) What syntax do I need to get the recordset back and the parameter in for my stored procedure? Thanks Karl Karl O'Sullivan Senior Analyst Programmer University Hospitals Coventry and Warwickshire NHS Trust Tel: 024 7660 2020 x7578 [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
