return data from Oracle stored procedure

[awi_fla]

Briefly, my ultimate goal is to retrieve data from a stored procedure on Oracle 10g. We are on CF8. I cannot use cfstoredproc due to the huge var size that I will eventually need to retrieve (a binary var from a blob to output as a pdf). Without going into details, using an Oracle stored procedure is required for this situation.

So I have found this code that is presented on various support sites as a "simple" example before actually trying to access the actual stored procedure, which I know works in Oracle.

But I cannot get this simple example to work:

<cfset

variables.plsql = " declare x number; begin x := 0; end; " >

<cfquery

name="q" datasource="(my datasource)">

#variables.plsql#

</cfquery>

The query appears to execute fine... no errors, but nothing is returned. If fact, an isdefined says the query results do not exist. Can X be returned into the query for use in CF?

Any ideas?

[Dan_Bracuk]

What would you expect to be returned?

Also, I think you are incorrect about not being able to use cfstoredproc.