| Passing Parameters from Oracle Apps to Reports 6i [message #136571] |
Thu, 08 September 2005 15:44  |
pkirangi
Messages: 74
Registered: August 2005
|
Member |
|
|
Hello All,
When I pass a parameter value from Oracle Applications to Reports 6i concurrent program, the value is not correctly passed to the report parameter, if the parameter value has a space in it.
For e.g if PARAM1 = 'ABC DEF GHI', then only ABC is passed to PARAM1 of the report.
Does anyone know of a solution to this, or is this a Bug.
Thanks in Advance.
Prashant
|
|
|
|
|
|
| Re: Passing Parameters from Oracle Apps to Reports 6i [message #136689 is a reply to message #136676] |
Fri, 09 September 2005 09:14  |
pkirangi
Messages: 74
Registered: August 2005
|
Member |
|
|
Hello Chakri,
Thanks for responding,
The Value set used is a TABLE Value Set, which returns a character string.
The List of values looks like this:
AAA BBB CCC
GGGG 78 KJHKK
hhjjj 888 99 JJHGJNHB
GHGHG
KKKKKK JJJ 7899 JJJ
Lets say I select the first value:
AAA BBB CCC and run the report, the concurrent program passes only AAA to the report.
If I select
GHGHG then everything is fine.
Thanks
Prashant H. K.
|
|
|
|
| Re: Passing Parameters from Oracle Apps to Reports 6i [message #136956 is a reply to message #136689] |
Mon, 12 September 2005 08:18 |
justchakri
Messages: 27
Registered: September 2005
Location: Bangalore
|
Junior Member |
|
|
Hi Prasanth,
I am writing some examplestry with tese running from TOAD or sql
SELECT SUBSTR('Prashant H. K.',1) FROM dual; -- returns full value
SELECT SUBSTR('Prashant H. K.',1,9 ) FROM dual; -- partial value
SELECT SUBSTR('Prashant H. K.',1,11) FROM dual; -- partial value
------------------------------
as you are telling your's is a table value set.
write the select stt. at table name place . while creating the value set.
And one more thing try to create a dummy report with the following select stt.
select substr(:p_name,1) from dual
it will create a parameter p_name of data type: character and Width :40
and run it by giving a value with space and without space seperately.
I think you got the logic !
Bye,
Chakri
[Updated on: Mon, 12 September 2005 08:24] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
