Parameters Error

I'm using paramenters against an ORACLE DB. The parameters works fine in
ORACLE but when I run the query inside the Development Enviroment of
Reporting Services it gives me an ORA-01008 error or it just quits the
application. The query is extremely simple and it doesn't work.
Please help...I'm running out of ideas in how make this to work.
--
Pato ConnonFirst I don't know Oracle... but I thought I read that Oracle parameter
placeholders are ? ie
select * from table where keyid = ?
THen map the ? to a report parameter... (perhaps?)
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Pato Connon" wrote:
> I'm using paramenters against an ORACLE DB. The parameters works fine in
> ORACLE but when I run the query inside the Development Enviroment of
> Reporting Services it gives me an ORA-01008 error or it just quits the
> application. The query is extremely simple and it doesn't work.
> Please help...I'm running out of ideas in how make this to work.
> --
> Pato Connon|||I found this posted by Robert Bruckner... Try it...
The managed Oracle provider (data source type: "Oracle") uses ":" instead of
"@." to identify parameters. Try this instead:
SELECT FirstName, LastName
FROM EmployeeInformation
WHERE EmployeeID = :ID
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Pato Connon" wrote:
> I'm using paramenters against an ORACLE DB. The parameters works fine in
> ORACLE but when I run the query inside the Development Enviroment of
> Reporting Services it gives me an ORA-01008 error or it just quits the
> application. The query is extremely simple and it doesn't work.
> Please help...I'm running out of ideas in how make this to work.
> --
> Pato Connon|||I'm doing that.
I have 2 queries. The first one like:
select name
from countries
The result it's used on a paramer called CountryName
and the second one
select client_name
from clientes
where client_country = :CountryName
This...in Oracle works fine...but in Reporting Services it doesn't.
And is extremely simple what I want to do. It also try to heritate the
result of a first parameter into a second one...and I also got a similar
problem.
--
Pato Connon
"Wayne Snyder" wrote:
> I found this posted by Robert Bruckner... Try it...
> The managed Oracle provider (data source type: "Oracle") uses ":" instead of
> "@." to identify parameters. Try this instead:
> SELECT FirstName, LastName
> FROM EmployeeInformation
> WHERE EmployeeID = :ID
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Pato Connon" wrote:
> > I'm using paramenters against an ORACLE DB. The parameters works fine in
> > ORACLE but when I run the query inside the Development Enviroment of
> > Reporting Services it gives me an ORA-01008 error or it just quits the
> > application. The query is extremely simple and it doesn't work.
> >
> > Please help...I'm running out of ideas in how make this to work.
> > --
> > Pato Connon|||Could be the version of ORACLE? Here we have two enviroments. The prodcution
enviroment it's an 8 version and the Testing enviroment it's a 9 version. The
same reports that didn't work against 8 worked perfectly in 9.
--
Pato Connon
"Pato Connon" wrote:
> I'm doing that.
> I have 2 queries. The first one like:
> select name
> from countries
> The result it's used on a paramer called CountryName
> and the second one
> select client_name
> from clientes
> where client_country = :CountryName
> This...in Oracle works fine...but in Reporting Services it doesn't.
> And is extremely simple what I want to do. It also try to heritate the
> result of a first parameter into a second one...and I also got a similar
> problem.
> --
> Pato Connon
>
> "Wayne Snyder" wrote:
> > I found this posted by Robert Bruckner... Try it...
> >
> > The managed Oracle provider (data source type: "Oracle") uses ":" instead of
> > "@." to identify parameters. Try this instead:
> >
> > SELECT FirstName, LastName
> > FROM EmployeeInformation
> > WHERE EmployeeID = :ID
> >
> >
> >
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> >
> > I support the Professional Association for SQL Server ( PASS) and it''s
> > community of SQL Professionals.
> >
> >
> > "Pato Connon" wrote:
> >
> > > I'm using paramenters against an ORACLE DB. The parameters works fine in
> > > ORACLE but when I run the query inside the Development Enviroment of
> > > Reporting Services it gives me an ORA-01008 error or it just quits the
> > > application. The query is extremely simple and it doesn't work.
> > >
> > > Please help...I'm running out of ideas in how make this to work.
> > > --
> > > Pato Connon