Yeah I was trying to get around the lack of support of Oracles OO side
by just using jdbc from within cfscript.
I was wondering how to call registerOutParameter(1,OracleTypes.CURSOR)
from within cfscript.
Thanks
Ryan
On Tue, 8 Feb 2005 10:02:46 -0500, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> I may be way off on this one, but I'm pretty sure the dataDirect
> drives will not convert an embedded cursor to an embedded cfquery.
> You're better off just rewriting your query as follows.
>
> SELECT dept.dname, emp.ename
> FROM dept INNER JOIN emp ON dept.deptno = emp.deptno
>
> That extra column of data shouldn't be too much needless overhead. As
> far as I can tell CF has no support at all for Oracles OO side.
>
> -Adam
>
>
> On Tue, 8 Feb 2005 09:17:42 -0500, Ryan Scott <[EMAIL PROTECTED]> wrote:
> > I am trying to use a query that contains an embedded cursor and I am
> > getting the following
> > error
> >
> > coldfusion.server.j2ee.sql.JRunCallableStatement.registerOutParameter(Ljava/lang/String;I)V
> >
> > I am using the datadirect jdbc drivers.
> >
> > <cfscript>
> > dsService = CreateObject("java",
> > "coldfusion.server.ServiceFactory").DataSourceService;
> > dsManager = dsService.getDman();
> > l_datasource = dsManager.getDataSource('<datasourcename>');
> > conn = l_datasource.getConnection();
> > OracleTypes = CreateObject("java", "oracle.jdbc.driver.OracleTypes");
> > String query = "begin "&
> > "open ? for "&
> > "'select dname, CURSOR(select ename "&
> > "from emp "&
> > "where
> > emp.deptno=dept.deptno) "&
> > "from dept'; "&
> > "end;";
> > cstmt = conn.prepareCall(query);
> > cstmt.registerOutParameter(1,OracleTypes.CURSOR);
> > cstmt.execute();
> > rset= cstmt.getObject(1);
> > </cfscript>
> >
> > Thanks
> > Ryan
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:193603
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
