Accessing Stored Procedures

[Guest_imported]

I have an Oracle DSN which is accessed by a ColdFusion Web Application.
I'd like to know how to access a stored procedure in this Oracle DataBase ???

Can I procede like this:

<cfquery name=&quot;selection&quot; datasource=&quot;test&quot;>

StoreProcedureName(Params);

</cfquery>

I'm waiting for help....

 

[texasdiver]

I use Oracle as a backend database and have no problems calling stored procedures using CFSTOREDPROC. Are using ODBC or the Oracle native drivers? [sig][/sig]

 

[gasparrelli]

You can use the CFSTOREDPROC and CFPROCPARAM tags, and there is a CFPROCRESULT as tag as well. Oracle isn't forthcoming in returning data sets from SP's, but you can pass back values using oracle's parameter OUT. CFStudio has the tags well documented and they are easy to use. Hope that helps address your question. [sig][/sig]