Yes it is an Oracle error. The parameter is preceded with an ':' as that is what Oracle wants as opposed to the '@' which is a SQL Server thing. Thanks!
'
We are converting our VS2008 reports to VS2015 and have come across an issue where some (not all) reports that have parameters are throwing an error ORA-01008 Not all variables bound. I have banged my head against the wall trying to figure out what is causing this. I ended up creating a brand...
I have 2 tables (table-A & table-B). They are defined as such:
TABLE-A
DEPARTMENT
ACCOUNT
TABLE-B
DEPARTMENT
ACCOUNT
SPEND
BUDGET
TABLE-A is my driver for my query as it has all the departments and accounts, whereas TABLE-B only has records for the departments and accounts that have either...
I'm a newbie using Crystal Reports 10. I am in the process of creating a report and have come across an issue that has stumped me.
My report needs to consist of 2 parts. The first part being the detail lines which is working fine, and the second part being the report totals page which is where...
I am trying to run the following sql but am getting an Oracle error ORA-00918: column ambiguously defined
select b.acct_unit, sum(b.budget_amount),
sum(s.spend_amount)
from uabhssd.vwuabbudget b full outer join
uabhssd.vwuabspend s on
b.fiscal_year = s.fiscal_year and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.