Michael, My experience has been that the easiest way to do this is:
<cfquery ...> select selRandomQuestionIDs() from dual; </cfquery> Others will likely suggest <cfstoredproc>, which I'm told is meant for just your situation. That said, I still prefer to select from dual (for no particular reason). Andrew On 12/7/05, Michael Bramwell <[EMAIL PROTECTED]> wrote: > Hi > > I am having troubles getting even basic Oracle sp's to call from my > coldfusion pages. > > Heres the procedure: > > CREATE OR REPLACE PROCEDURE selRandomQuestionIDs() AS > IS > BEGIN > SELECT quizQuestionID, RANDOM_ORDER > FROM random_number > WHERE rownum <= 20 > END; > > Heres the call: > > <cfquery name="selRandomQuestionIDs" datasource="#datasourceName#"> > BEGIN selRandomQuestionIDs(); END; > </cfquery> > > The error being returned is as follows: > > [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: > PLS-00905: object SYSTEM.SELRANDOMQUESTIONIDS is invalid ORA-06550: line 1, > column 7: PL/SQL: Statement ignored > > Any help will be most appreciated. > > Cheers, > > Michaelb. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226534 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
