Home » Developer & Programmer » Reports & Discoverer » DYNAMIC LIST IN OTM
icon9.gif  DYNAMIC LIST IN OTM [message #261267] Wed, 22 August 2007 04:24 Go to next message
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

Re: DYNAMIC LIST IN OTM [message #261303 is a reply to message #261267] Wed, 22 August 2007 05:18 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: DYNAMIC LIST IN OTM [message #261312 is a reply to message #261303] Wed, 22 August 2007 05:27 Go to previous message
nishasundar
Messages: 4
Registered: August 2007
Junior Member
Hai,
Thank you for your reply.

regards,
S.Nisha
Previous Topic: Oracle Character Set Issue
Next Topic: dynamic linking of reports
Goto Forum:
  


Current Time: Sun Dec 11 02:43:43 CST 2016

Total time taken to generate the page: 0.08117 seconds