Paging in Oracle
0 views
Skip to first unread message
Russ
Nov 18, 2008, 6:29:23 PM11/18/08
to S#arp Architecture
Maybe you guys can help me out with this one. I am using an older
version of S#arp for a project (Back when it was still called
ProjectBase), and I recently upgraded the nhib reference to 2.1. All
seems fine except for paging via SetFirstResult and SetMaxResults. We
are using Oracle 10g and I receive the following exception when I
attempt to do any paging.
System.Data.OracleClient.OracleException: ORA-01036: illegal variable
name/number
When I remove the paging, all is well. In addition, none of this code
has been modified. The only difference is the new nhib assembly.
Thanks.
version of S#arp for a project (Back when it was still called
ProjectBase), and I recently upgraded the nhib reference to 2.1. All
seems fine except for paging via SetFirstResult and SetMaxResults. We
are using Oracle 10g and I receive the following exception when I
attempt to do any paging.
System.Data.OracleClient.OracleException: ORA-01036: illegal variable
name/number
When I remove the paging, all is well. In addition, none of this code
has been modified. The only difference is the new nhib assembly.
Thanks.
Billy
Nov 22, 2008, 6:41:52 PM11/22/08
to S#arp Architecture
Hi Russ,
If you're still having trouble with this, you may want to post to the
NHibernate forums at http://forum.hibernate.org/viewforum.php?f=25.
Thanks,
Billy
If you're still having trouble with this, you may want to post to the
NHibernate forums at http://forum.hibernate.org/viewforum.php?f=25.
Thanks,
Billy
Reply all
Reply to author
Forward
0 new messages