OraFAQ Forum: Reports & Discoverer » DYNAMIC LIST IN OTM

Home » Developer & Programmer » Reports & Discoverer » DYNAMIC LIST IN OTM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DYNAMIC LIST IN OTM [message #261267]

Wed, 22 August 2007 04:24

nishasundar
Messages: 4
Registered: August 2007

Junior Member

Hai all,
Is it possible to fetch the 'Provider ID' from the database and populate it in the Provider ID drop down of the report?

i tried this in OTM by selecting the following:
1. Parameter Type - is 'Dynamic List' and
2. Query Name - i selected from the picklist(already existing one)
Then the provider Id's are displaying in the drop down list but if i select anyone and click Submit button then it shows an Error like this :
REP-300: quoted string not properly terminated

Note:i tried the same in the report builder also but it also shows some error like "Invalid Identifier"

Kindly help me to solve this problem.

thanks & regards,
S.Nisha

Report message to a moderator

Re: DYNAMIC LIST IN OTM [message #261303 is a reply to message #261267]

Wed, 22 August 2007 05:18

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

REP-300: ORACLE error occurred.
Cause: Reports Builder encountered an ORACLE error.

Action: Scroll through the error message to see where the error occurred and, if possible, fix it. Otherwise, contact your DBA.

Oracle

ORA-01756: quoted string not properly terminated

Cause: A quoted string must be terminated with a single quote mark (').

Action: Insert the closing quote and retry the statement.

I'd say that your main problem is not "is it possible", but "how to do it properly".

P.S. I have no idea what "OTM" is.

Report message to a moderator

Re: DYNAMIC LIST IN OTM [message #261312 is a reply to message #261303]

Wed, 22 August 2007 05:27

nishasundar
Messages: 4
Registered: August 2007

Junior Member

Hai,
Thank you for your reply.

regards,
S.Nisha

Report message to a moderator

Previous Topic:	Oracle Character Set Issue
Next Topic:	dynamic linking of reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 12:14:11 CDT 2024