cfstoredproc request times out

[robersot]

I am attempting to call a stored procedure using the cfstoredproc tag and no
matter what I try I get "The request has exceeded the allowable time limit
Tag: CFSTOREDPROC" I have tried several different stored procedures. Each
procedure works when called from SQL Plus. This is the latest, simplest
procedure I am trying to call using ColdFusion:

CREATE OR REPLACE PROCEDURE my_procedure
IS
BEGIN
NULL;
END;

This is the ColdFusion code I am using to call the procedure:

<cfstoredproc procedure="my_procedure" datasource="test"></cfstoredproc>

I am running ColdFusion MX 6.1 and accessing Oracle 10g via the Oracle Thin
Driver. I have tested this on both Windows 2000 Server and Red Hat Enterprise.
I appreciate any insight. Thank you.

[wiseguy21]

sounds like it may be a permissions issue. What account are you using to try an execute the SP? Since you are logging into SQL*PLUS, try to use your login creditials in cfstoredproc tag.

[robersot]

Thanks for your response. I am connecting with the same account from SQL Plus
and ColdFusion. I actually think this may be an issue with executing stored
procdures using the Oracle Thin Driver. I am only running standard edition so I
don't have the Oracle driver that comes packaged with other ColdFusion
versions.

[wiseguy21]

have your tried executing the SP from within a <cfquery> tag? I haven't done it this way before, but I know you can. (Just grabbing at straws here.)